Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I am using a KPI with the format "Auto" to calculate money. it could be Million or Billion which I want to show. But I would like to have only one digit after the dot. I would like to see e.g. 198.5 M or 45.4 B. But the system makes 2 digits.
where can i change that?
Best regards
Pia
If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'0.0 B'), Num(sum(Amount)/1000000,'0.0 M'))
If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'0.0 B'), Num(sum(Amount)/1000000,'0.0 M'))