topic Re: DecimalSep and ThousandSep: it doesn`t show the right way on sheet in App Development

DecimalSep and ThousandSep: it doesn`t show the right way on sheet

Paulo_IntelFab — Mon, 07 Oct 2024 16:21:51 GMT

I need to show numeric values in the Brazilian format: 1.000,00 (decimal separator is a comma and thousand separator a final point).

I've set this parameters on the load script. In the visualization area, it shows the correct format, as shown in the picture:

But, on the visualization (sheet) it remains using the standard DecimalSep (.) and ThousandSep (,).
The date filter used on sheet respects the Brazilian date format that I've set on the load script (DD/mm/YYYY).

Is there anything I missed? I appreciate any help.

Re: DecimalSep and ThousandSep: it doesn`t show the right way on sheet

Or — Mon, 07 Oct 2024 17:01:45 GMT

Check the master measure's formatting, both in the sense that it may have expression-level formatting (using the num() function) or a default format that is not what you want. Also, check for any formatting at the object level. Something worth looking at - open the Selections screen, find your field, and see what the format is there without any expressions applied.

Re: DecimalSep and ThousandSep: it doesn`t show the right way on sheet

Paulo_IntelFab — Mon, 07 Oct 2024 18:16:34 GMT

Thanks for Helping, @Or .
I searched the object and found the "customize" format option. Applying this to the objects, it takes the values defined on the load script by default.

It`s configured object by object (even inside tables), but it works fine.