Commas when uploading a report in xls
We made such a report https://mariemur.crm-onebox.com/admin/report/designer/4/view/
Click upload to xls
In the table, the product has a price of 27.6
When uploading to xls - it writes in the date format 06/27/2021
It is necessary to unload in numerical format, as I understand it, for this there should be not a dot, but a comma
Tell me how to do it, or evaluate the refinement if the standard settings cannot be done
Original question is available on version: ru
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Click upload to xls
In the table, the product has a price of 27.6
When uploading to xls - it writes in the date format 06/27/2021
It is necessary to unload in numerical format, as I understand it, for this there should be not a dot, but a comma
Tell me how to do it, or evaluate the refinement if the standard settings cannot be done
Answers:
use number_format for the variable to replace the dot with a comma in the right places
25.05.2021, 13:09
Original comment available on version: ru
snowball
Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote:
use number_format for the variable to replace the dot with a comma in the right places
This is the first time I've seen this, but can you give an example of how to use it?
25.05.2021, 16:34
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
{|variable|number_format:2:"":","|}
like something like that
like something like that
25.05.2021, 16:53
Original comment available on version: ru
snowball
Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote:
{|variable|number_format:2:"":","|}
like something like that
Didn't work, empty cell after saving
It was like this {row:product_customOrderproduct_summ_product_USD}
Put it like this {|row:product_customOrderproduct_summ_product_USD|number_format:2:"":","|}
And the void became
26.05.2021, 10:49
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
snowball
Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote:
| take away
I tried to remove it
{|row:product_customOrderproduct_summ_product_USD|number_format:2:"":","}
{row:product_customOrderproduct_summ_product_USD|number_format:2:"":","|}
But substitutes emptiness
27.05.2021, 13:57
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
snowball
Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote:
both | need to be removed
Tried like this
{row:product_customOrderproduct_summ_product_USD|number_format:2:"":","}
And so without separators at all
{row:product_customOrderproduct_summ_product_USDnumber_format:2:"":","}
Does not help
Write on the example of this variable as exactly as you need, or you can test it yourself in this report
28.05.2021, 11:54
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
there are smart variables, which means they don’t eat in their usual form, now I’ll see what can be done
28.05.2021, 13:07
Original comment available on version: ru
Made https://mariemur.crm-onebox.com/admin/report/desiner/4/view/ , look here how it should work or not?
28.05.2021, 13:12
Original comment available on version: ru
snowball
Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote:
Made https://mariemur.crm-onebox.com/admin/report/desiner/4/view/ , look here how it should work or not?
Nothing has changed, prices are loaded in xls with a dot in the date format, but you need to separate them with commas
28.05.2021, 13:19
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
snowball
Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote:
added a comma instead of a dot
beautiful
28.05.2021, 13:35
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
