sense UI extension format pattern

[ioannaiogr]

Hello all! 🌼

So i've been trying to figure out why i can't have results like 100.000 when i use this

(num(count(distinct ID), '#.##0', ',', '.'))    along with "Measure expression" format from the list box...

I tried doing custom, or change number format to #.##0 but it keeps giving me 100K.

The problem is that the number gets rounded. For example i have 592.600 and it shows 593K.

The only instance it shows without rounding is if i leave it with one or two decimals format: 592.600,00 or 592.600,0 .

Do you maybe know what I need to do?

Thank you in advance

[Chanty4u]

Try this 

=num#(count(distinct ID), '#.##0', ',', '.')

make sure that the format is correctly applied to the expression by checking the format of the chart's measure in the properties panel. If it's set to 'Auto', try changing it to 'Custom' and enter your desired format.

[ioannaiogr]

Hi @Chanty4u , still no luck. Thank you very much though

[Chanty4u]

Try something like below

=num(count(distinct ID), '#,##0.00', '.', ',')

Or

 =Num#(count(distinct ID), '#,##0.00', '.')

[ioannaiogr]

No, returns just 593K. It works for you?

[Chanty4u]

Try this 

=num(count(distinct ID), '#.###.##0')

Or in custom format use below

'#,###.##0'

[ioannaiogr]

Nope, unfortunately, that's not it. 😞

I still have this problem so I could use any help!