Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Contributor III

Re: Rounding Financial Data

Yes make try to divide for 1000 and then round.

like round(sum(field)/1000)

1 Reply
arthur_dom
Contributor III

Re: Rounding Financial Data

Yes make try to divide for 1000 and then round.

like round(sum(field)/1000)