topic Re: Calculation-Problem in diagram in QlikView https://community.qlik.com/t5/QlikView/Calculation-Problem-in-diagram/m-p/1441018#M459304 <HTML><HEAD></HEAD><BODY><P>What you provide the expression will work. And it works and starts from Left - Right. Ref image attacched</P><P></P><P><IMG alt="Order_of_Prec.gif" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179373_Order_of_Prec.gif" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Thu, 12 Oct 2017 09:05:04 GMT Anil_Babu_Samineni 2017-10-12T09:05:04Z Calculation-Problem in diagram https://community.qlik.com/t5/QlikView/Calculation-Problem-in-diagram/m-p/1441017#M459303 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to calculate a field in a diagram:</P><P></P><P>(sum(Price1)+sum(price2)) / sum(cost)</P><P></P><P>It doesn't work right: Do u have any idea how to get multiplication and division first, then addition and subtraction?</P><P></P><P>THX</P></BODY></HTML> Thu, 12 Oct 2017 08:45:33 GMT https://community.qlik.com/t5/QlikView/Calculation-Problem-in-diagram/m-p/1441017#M459303 Anonymous 2017-10-12T08:45:33Z Re: Calculation-Problem in diagram https://community.qlik.com/t5/QlikView/Calculation-Problem-in-diagram/m-p/1441018#M459304 <HTML><HEAD></HEAD><BODY><P>What you provide the expression will work. And it works and starts from Left - Right. Ref image attacched</P><P></P><P><IMG alt="Order_of_Prec.gif" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179373_Order_of_Prec.gif" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Thu, 12 Oct 2017 09:05:04 GMT https://community.qlik.com/t5/QlikView/Calculation-Problem-in-diagram/m-p/1441018#M459304 Anil_Babu_Samineni 2017-10-12T09:05:04Z Re: Calculation-Problem in diagram https://community.qlik.com/t5/QlikView/Calculation-Problem-in-diagram/m-p/1441019#M459305 <HTML><HEAD></HEAD><BODY><P>Do you mean this:</P><P></P><P><EM>=Sum((Price1 + Price2)/Cost)</EM></P><P></P><P>Although I would do this rather - it will handle nulls properly:</P><P></P><P><EM style="font-size: 13.3333px;">=Sum(RangeSum(Price1, Price2)/Cost)</EM></P></BODY></HTML> Thu, 12 Oct 2017 09:16:46 GMT https://community.qlik.com/t5/QlikView/Calculation-Problem-in-diagram/m-p/1441019#M459305 jonathandienst 2017-10-12T09:16:46Z