topic Re: Incorrect Sum from Measure in App Development https://community.qlik.com/t5/App-Development/Incorrect-Sum-from-Measure/m-p/103486#M6967 <HTML><HEAD></HEAD><BODY><P>May be:</P><P></P><P>=SUM(aggr(Sum(weight_base / 1000000) * only(qty_base), order_product_inventory_id,Field2))</P></BODY></HTML> Tue, 21 Aug 2018 14:14:34 GMT BalaBhaskar_Qlik 2018-08-21T14:14:34Z Incorrect Sum from Measure https://community.qlik.com/t5/App-Development/Incorrect-Sum-from-Measure/m-p/103484#M6965 <HTML><HEAD></HEAD><BODY><P>I have a measure that shows us the weight of products sold per order, but when used in pivot table, the total sum is shown incorrectly.&nbsp; Has anyone experienced this issue previously?&nbsp; If so, what is a possible solution so that the correct total weight is shown?&nbsp; Below is expression I am using:</P><P></P><P>SUM(aggr(Sum(distinct (weight_base / 1000000) * qty_base), order_product_inventory_id))</P><P></P><P>Thanks in advance for help.</P></BODY></HTML> Mon, 20 Aug 2018 16:30:50 GMT https://community.qlik.com/t5/App-Development/Incorrect-Sum-from-Measure/m-p/103484#M6965 Anonymous 2018-08-20T16:30:50Z Re: Incorrect Sum from Measure https://community.qlik.com/t5/App-Development/Incorrect-Sum-from-Measure/m-p/103485#M6966 <HTML><HEAD></HEAD><BODY><P>Maybe there are further dimensions within the pivot which aren't covered within the aggr().</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 21 Aug 2018 11:09:13 GMT https://community.qlik.com/t5/App-Development/Incorrect-Sum-from-Measure/m-p/103485#M6966 marcus_sommer 2018-08-21T11:09:13Z Re: Incorrect Sum from Measure https://community.qlik.com/t5/App-Development/Incorrect-Sum-from-Measure/m-p/103486#M6967 <HTML><HEAD></HEAD><BODY><P>May be:</P><P></P><P>=SUM(aggr(Sum(weight_base / 1000000) * only(qty_base), order_product_inventory_id,Field2))</P></BODY></HTML> Tue, 21 Aug 2018 14:14:34 GMT https://community.qlik.com/t5/App-Development/Incorrect-Sum-from-Measure/m-p/103486#M6967 BalaBhaskar_Qlik 2018-08-21T14:14:34Z