https://community.qlik.com/t5/App-Development/Aproximate-metric-volumes/m-p/2509023#M104640 <P>hi,&nbsp;</P> <P>&nbsp;</P> <P>I have a kpi with a metric that is showing in millions like 35.76 M. how can I change this to only show 36 M( from 35.76 approximate to 36 M)&nbsp;</P> <P>&nbsp;</P> <P>My measure it is configured to showa number 1,000 but for millions shows 35.76 milions.&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="l26b_0-1741610833572.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178320i5BFCB0D9B16C538A/image-size/medium?v=v2&amp;px=400" role="button" title="l26b_0-1741610833572.png" alt="l26b_0-1741610833572.png" /></span></P> <P>&nbsp;</P> <P>thank you&nbsp;</P> Mon, 10 Mar 2025 12:47:33 GMT l26b 2025-03-10T12:47:33Z https://community.qlik.com/t5/App-Development/Aproximate-metric-volumes/m-p/2509023#M104640 <P>hi,&nbsp;</P> <P>&nbsp;</P> <P>I have a kpi with a metric that is showing in millions like 35.76 M. how can I change this to only show 36 M( from 35.76 approximate to 36 M)&nbsp;</P> <P>&nbsp;</P> <P>My measure it is configured to showa number 1,000 but for millions shows 35.76 milions.&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="l26b_0-1741610833572.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178320i5BFCB0D9B16C538A/image-size/medium?v=v2&amp;px=400" role="button" title="l26b_0-1741610833572.png" alt="l26b_0-1741610833572.png" /></span></P> <P>&nbsp;</P> <P>thank you&nbsp;</P> Mon, 10 Mar 2025 12:47:33 GMT https://community.qlik.com/t5/App-Development/Aproximate-metric-volumes/m-p/2509023#M104640 l26b 2025-03-10T12:47:33Z https://community.qlik.com/t5/App-Development/Aproximate-metric-volumes/m-p/2509113#M104659 <P>Try this&nbsp;</P> <P>Round(Sum(YourMetric) / 1000000, 1) &amp; ' M'</P> <P>&nbsp;</P> Mon, 10 Mar 2025 18:09:28 GMT https://community.qlik.com/t5/App-Development/Aproximate-metric-volumes/m-p/2509113#M104659 Chanty4u 2025-03-10T18:09:28Z