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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rounding Financial Data

Is there a way to round my data like this:

I have a pivot table and let's say the total is showing 92,703,816

Is there a way to get it to show 92,704 instead?????

1 Solution

Accepted Solutions
arthur_dom
Creator III
Creator III

Yes make try to divide for 1000 and then round.

like round(sum(field)/1000)

View solution in original post

1 Reply
arthur_dom
Creator III
Creator III

Yes make try to divide for 1000 and then round.

like round(sum(field)/1000)