How to change the number format

[abc_18]

Hi,

In my dashboard, I have a expression where data is coming as 590.988, I want to replace the decimal with comma separator like 590,988

Please suggest.

Thanks

[Chanty4u]

try this

Replace(Value,',','.');

or

SET DecimalSep=','; // . instead of .

[Chanty4u]

check this

Get comma separated values of a field

[abc_18]

Hi Chanty,

I changed the DecimalSep, but still I am getting value as 590.988.

I tried to use the 'num' function, but not getting proper output.

[Anil_Babu_Samineni]

You said, You have expression. What expression you have?

[abc_18]

Expression is:-

if(%CurrencyDesc = 'D&C Currency',sum($(curr_year)sales_sm_fxa)/vPer,sum($(curr_year)[sales_$(vCurrency_Fxx)])/vPer)

and I am trying to change the format using 'num' function

[Anil_Babu_Samineni]

May be this?

if(%CurrencyDesc = 'D&C Currency',Num(sum($(curr_year)sales_sm_fxa)/vPer, ''#,##,##0'),Num(sum($(curr_year)[sales_$(vCurrency_Fxx)])/vPer, ''#,##,##0'))

[Anonymous]

Shikha , I guess your currency format is in Euro and assuming this is something that was changed in the main tab. Check SET money format.

[neha_shirsath]

In your data field its comma? or after calculation its showing like this?

[el_aprendiz111]

Hi,

=NUM(590.988,'#,###',',','.')