topic Re: Exponential Value into Number in QlikView https://community.qlik.com/t5/QlikView/Exponential-Value-into-Number/m-p/1369732#M418755 <HTML><HEAD></HEAD><BODY><P>-2.8189506969926e-008*100000000</P></BODY></HTML> Tue, 25 Jul 2017 16:37:17 GMT Frank_Hartmann 2017-07-25T16:37:17Z Exponential Value into Number https://community.qlik.com/t5/QlikView/Exponential-Value-into-Number/m-p/1369731#M418754 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P>In one of the report ,One of My Key figure field returning values like this -2.8189506969926e-008 but when I am using in straight table or Pivot table it is showing as -0 amount but i want key figure should be display like -2.8 in the table . I am using number format in Number tab&nbsp; fixed upto one decimal.</P><P></P><P>Please suggest me any Idea to fix this Issue. It is Urgent.</P><P></P><P></P><P>Regards</P><P>Deepak</P></BODY></HTML> Tue, 25 Jul 2017 16:31:50 GMT https://community.qlik.com/t5/QlikView/Exponential-Value-into-Number/m-p/1369731#M418754 2017-07-25T16:31:50Z Re: Exponential Value into Number https://community.qlik.com/t5/QlikView/Exponential-Value-into-Number/m-p/1369732#M418755 <HTML><HEAD></HEAD><BODY><P>-2.8189506969926e-008*100000000</P></BODY></HTML> Tue, 25 Jul 2017 16:37:17 GMT https://community.qlik.com/t5/QlikView/Exponential-Value-into-Number/m-p/1369732#M418755 Frank_Hartmann 2017-07-25T16:37:17Z Re: Exponential Value into Number https://community.qlik.com/t5/QlikView/Exponential-Value-into-Number/m-p/1369733#M418756 <HTML><HEAD></HEAD><BODY><P>or</P><P></P><P>num(-2.8189506969926e-008,'#.##,###############')*100000000</P></BODY></HTML> Tue, 25 Jul 2017 16:40:47 GMT https://community.qlik.com/t5/QlikView/Exponential-Value-into-Number/m-p/1369733#M418756 Frank_Hartmann 2017-07-25T16:40:47Z