topic How to calculate in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1223686#M390923 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>Please help</P><P></P><P>Attached samples, Some how I am not able to calculate <STRONG>PPV Amount</STRONG> expression last column in proper ,Expected result was in text box </P><P></P><P>Thanks in Advance </P></BODY></HTML> Wed, 09 Nov 2016 15:24:17 GMT dseelam 2016-11-09T15:24:17Z How to calculate https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1223686#M390923 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>Please help</P><P></P><P>Attached samples, Some how I am not able to calculate <STRONG>PPV Amount</STRONG> expression last column in proper ,Expected result was in text box </P><P></P><P>Thanks in Advance </P></BODY></HTML> Wed, 09 Nov 2016 15:24:17 GMT https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1223686#M390923 dseelam 2016-11-09T15:24:17Z Re: How to calculate https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1223687#M390924 <HTML><HEAD></HEAD><BODY><P>Hi Dinesh, some parenthesys was left:</P><P><SPAN style="color: #ff0000;"><STRONG>(</STRONG></SPAN>sum(Price+(Price*Duty%)+Freight)-([Frozen Cost])<SPAN style="color: #ff0000;"><STRONG>)</STRONG></SPAN>*Qty</P><P></P><P>And for use monetary values (max 2 decimals for what I see in the table):</P><P>Round((sum(Price+(Price*Duty%)+Freight)-([Frozen Cost])), 0.01)*Qty</P></BODY></HTML> Wed, 09 Nov 2016 15:42:05 GMT https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1223687#M390924 rubenmarin 2016-11-09T15:42:05Z Re: How to calculate https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1223688#M390925 <HTML><HEAD></HEAD><BODY><P>It was so dumb I dint notices it thanks Ruben </P></BODY></HTML> Wed, 09 Nov 2016 15:45:57 GMT https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1223688#M390925 dseelam 2016-11-09T15:45:57Z