Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Gump123
Contributor
Contributor

converting whole number into thousend

I have revenue in KPI 

sum({<isavi= {'Y'}>}[Total Revenue])

which get me    $4526116615.55

no i want that number to be shown as 452.6K . 

 

I tried auto format but not working.

1 Reply
Or
MVP
MVP

452.6K is 452600, assuming standard numeric abbreviations (K = 1000). Your number is 4,526,116,615, which is several orders of magnitude larger.