topic Rounding Financial Data in QlikView https://community.qlik.com/t5/QlikView/Rounding-Financial-Data/m-p/642428#M543517 <HTML><HEAD></HEAD><BODY><P>Is there a way to round my data like this:</P><P></P><P>I have a pivot table and let's say the total is showing 92,703,816</P><P>Is there a way to get it to show 92,704 instead?????</P></BODY></HTML> Wed, 21 May 2014 19:34:50 GMT 2014-05-21T19:34:50Z Rounding Financial Data https://community.qlik.com/t5/QlikView/Rounding-Financial-Data/m-p/642428#M543517 <HTML><HEAD></HEAD><BODY><P>Is there a way to round my data like this:</P><P></P><P>I have a pivot table and let's say the total is showing 92,703,816</P><P>Is there a way to get it to show 92,704 instead?????</P></BODY></HTML> Wed, 21 May 2014 19:34:50 GMT https://community.qlik.com/t5/QlikView/Rounding-Financial-Data/m-p/642428#M543517 2014-05-21T19:34:50Z Re: Rounding Financial Data https://community.qlik.com/t5/QlikView/Rounding-Financial-Data/m-p/642429#M543518 <HTML><HEAD></HEAD><BODY><P>Yes make try to divide for 1000 and then round.</P><P>like round(sum(field)/1000) </P></BODY></HTML> Wed, 21 May 2014 19:36:20 GMT https://community.qlik.com/t5/QlikView/Rounding-Financial-Data/m-p/642429#M543518 arthur_dom 2014-05-21T19:36:20Z