topic Re: How to reduce decimal places on format pattern in App Development https://community.qlik.com/t5/App-Development/How-to-reduce-decimal-places-on-format-pattern/m-p/791930#M11020 <HTML><HEAD></HEAD><BODY><P>You would need to divide the value by 1000000000&nbsp; (one billion) and then use a format mask with a B on the end. </P><P></P><P><IMG alt="Untitled.png" class="jive-image" height="291" src="https://community.qlik.com/legacyfs/online/70764_Untitled.png" style="width: 651px; height: 290.73786407767px;" width="651" /></P></BODY></HTML> Fri, 07 Nov 2014 20:39:16 GMT JonnyPoole 2014-11-07T20:39:16Z How to reduce decimal places on format pattern https://community.qlik.com/t5/App-Development/How-to-reduce-decimal-places-on-format-pattern/m-p/791929#M11019 <HTML><HEAD></HEAD><BODY><P>I have a value of £1,000,000,000,000 I want this down to £1,000B or similar.</P><P></P><P>Any help would be good.</P></BODY></HTML> Fri, 07 Nov 2014 17:34:13 GMT https://community.qlik.com/t5/App-Development/How-to-reduce-decimal-places-on-format-pattern/m-p/791929#M11019 2014-11-07T17:34:13Z Re: How to reduce decimal places on format pattern https://community.qlik.com/t5/App-Development/How-to-reduce-decimal-places-on-format-pattern/m-p/791930#M11020 <HTML><HEAD></HEAD><BODY><P>You would need to divide the value by 1000000000&nbsp; (one billion) and then use a format mask with a B on the end. </P><P></P><P><IMG alt="Untitled.png" class="jive-image" height="291" src="https://community.qlik.com/legacyfs/online/70764_Untitled.png" style="width: 651px; height: 290.73786407767px;" width="651" /></P></BODY></HTML> Fri, 07 Nov 2014 20:39:16 GMT https://community.qlik.com/t5/App-Development/How-to-reduce-decimal-places-on-format-pattern/m-p/791930#M11020 JonnyPoole 2014-11-07T20:39:16Z