Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this situation:
R$
100
1.000
1.000.000
1.000.000.000
And using this expreesion I can treat and show the same values, but with another mask in a KPI:
100
R$ 1 K
R$ 1 M
R$ 1 B
But when I look the 100, i don't have the currency format.
I need help
Expression:
if(Sum(valor) < 1000000000, num(Sum(valor)/1000000000, 'R$ #.##0', ',', '.') & pick(floor(log10(sum(valor))/3)+1,'',' K',' M',' B'),
if(Sum(valor) > 1000000, num(Sum(valor)/1000000, 'R$ #.##0', ',', '.') & pick(floor(log10(sum(valor))/3)+1,'',' K',' M',' B'),
if(Sum(valor) > 1000, num(Sum(valor)/1000, 'R$ #.##0', ',', '.') & pick(floor(log10(sum(valor))/3)+1,'',' K',' M',' B'),
(num(Sum(valor), 'R$ #.##0,', ',', '.') & pick(floor(log10(sum(valor))/3)+1,'',' K',' M',' B'))
)))
This is what you can try..
You can try with Money function instead of Num. Also can you please post sample qvw to better understand the issue?