Format currency as a KPI

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have this situation:

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'))

)))

Re: Format currency as a KPI

MK_QSL — Tue, 27 Dec 2016 16:40:45 GMT

This is what you can try..

Tue, 27 Dec 2016 16:41:20 GMT

You can try with Money function instead of Num. Also can you please post sample qvw to better understand the issue?