Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
Replace(Value,',','.');
or
SET DecimalSep=','; // . instead of .
check this
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.
You said, You have expression. What expression you have?
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
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'))
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.
In your data field its comma? or after calculation its showing like this?
Hi,
=NUM(590.988,'#,###',',','.')