Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
peisenrot
Contributor III
Contributor III

digits after dot on KPI with Format "Auto"

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 

Labels (1)
1 Solution

Accepted Solutions
anat
Master
Master

If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'0.0 B'), Num(sum(Amount)/1000000,'0.0 M'))

View solution in original post

1 Reply
anat
Master
Master

If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'0.0 B'), Num(sum(Amount)/1000000,'0.0 M'))