topic Re: Set Decimal in script level in QlikView https://community.qlik.com/t5/QlikView/Set-Decimal-in-script-level/m-p/655984#M239527 <HTML><HEAD></HEAD><BODY><P>in script</P><P>round(sum(amount)/30, 0.01)</P></BODY></HTML> Sat, 18 Oct 2014 12:54:13 GMT maxgro 2014-10-18T12:54:13Z Set Decimal in script level https://community.qlik.com/t5/QlikView/Set-Decimal-in-script-level/m-p/655982#M239525 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want a result like :</P><P>suppose my actual result which&nbsp; is coming 1234.229 and i want to convert it into 1234.23</P><P></P><P>formula in script is:</P><P>Sum(amount)/30</P><P></P><P>so what function i have to use in this to take first&nbsp; 2 digits after decimal.</P><P></P><P>Thanks in advance.</P><P></P><P></P><P>Narender</P></BODY></HTML> Sat, 18 Oct 2014 10:28:58 GMT https://community.qlik.com/t5/QlikView/Set-Decimal-in-script-level/m-p/655982#M239525 narender123 2014-10-18T10:28:58Z Re: Set Decimal in script level https://community.qlik.com/t5/QlikView/Set-Decimal-in-script-level/m-p/655983#M239526 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Num(Sum(amount)/30,'#0.00')</SPAN></P></BODY></HTML> Sat, 18 Oct 2014 11:06:19 GMT https://community.qlik.com/t5/QlikView/Set-Decimal-in-script-level/m-p/655983#M239526 MarcoWedel 2014-10-18T11:06:19Z Re: Set Decimal in script level https://community.qlik.com/t5/QlikView/Set-Decimal-in-script-level/m-p/655984#M239527 <HTML><HEAD></HEAD><BODY><P>in script</P><P>round(sum(amount)/30, 0.01)</P></BODY></HTML> Sat, 18 Oct 2014 12:54:13 GMT https://community.qlik.com/t5/QlikView/Set-Decimal-in-script-level/m-p/655984#M239527 maxgro 2014-10-18T12:54:13Z