Separator for custom expression

[#1]

Hi all,

I am using the following expression in a text object to display the value. I want to separate as millions thousands hundreds (basically thousand separator) .

=NUM(count( { < Year={$(=varCurrYear)} , type= {'A','B'}> } type ))

TIA,

J

[sunny_talwar]

May be this:

=Num(Count({<Year = {$(=varCurrYear)}, type= {'A','B'}>} type), '#,##0.0')

[#3]

try this .....

=NUM(count( { < Year={$(=varCurrYear)} , type= {'A','B'}> } type ),'#,###')

Mark this helpful/correct answer as applicable please.

[#4]

Thanks for your reply. I forgot to add something in my actual thread.

If the result is 200743 it should be displayed as 2 00 743

If the result is 123456.87 it should be displayed as 1 23 456,87

If the result is 98765432109.03 it should be displayed as 98 76 54 32 109,03

Please advise an expression for this.

[sunny_talwar · Accepted solution]

Try this:

=Num('98765432109.03', '## ## ## ## ##0,00', ',', ' ')

And this for your expression:

=Num(Count({<Year = {$(=varCurrYear)}, type= {'A','B'}>} type), '## ## ## ## ##0,00', ',', ' ')

[#6]

I am getting error in expression How to search on this topic ? I want different separator for different text objects in my dashboard. Please help me with a link that provides all these.

-J

[sunny_talwar]

What is the error you are getting? Have you tried the hard-coded expression in a text box object?

[#8]

Sorry ! I missed the comma next to the number

Thanks Sunny !