
Partial Sum
Sridhar Ethiraj Dec 2, 2011 10:57 PM (in response to Tracy Crown)Hi,
Could please elaborate your question with expected answer?
Total Amount Could be also calculated using =sum(Cost*Qty) formulae.
Avg Unit Cost could be calculated using Avg(Cost).
If this is not you are expecting then give us the some more information you question with expected answers.
Sridhar

Re: Partial Sum
Tracy Crown Dec 3, 2011 1:31 AM (in response to Sridhar Ethiraj)Dear Sridhar
The Total for Amount is correct now ($4339) but not the Total Unit Cost ($65.4), it should be Total Amount/Total Qty = ($4339/64=$67.8).
Thank you
Tracy
Date: Fri, 2 Dec 2011 22:57:54 0500
From: qliktech@sgaur.hosted.jivesoftware.com
QlikCommunity
Re: Partial Sum created by Sridhar Ethiraj in Development (QlikView Desktop)  View the full discussion
Hi,
Could please elaborate your question with expected answer?
Total Amount Could be also calculated using =sum(Cost*Qty) formulae.
Avg Unit Cost could be calculated using Avg(Cost).
If this is not you are expecting then give us the some more information you question with expected answers.
Sridhar
Reply to this message by replying to this email or go to the message on QlikCommunity
Start a new discussion in Development (QlikView Desktop) by email or at QlikCommunity
© 19932011 QlikTech International AB Copyright & Trademarks  Privacy  Terms of Use  Software EULA

Testing1[1].qvw 155.0 K

Re: Partial Sum
Sridhar Ethiraj Dec 3, 2011 5:18 AM (in response to Tracy Crown)You can use this below formulae to calculate Total Unit Cost
sum(Cost*Qty)/sum(Qty)
Sridhar

Re: Partial Sum
Tracy Crown Dec 3, 2011 10:52 AM (in response to Sridhar Ethiraj)Dear Sridhar
Unit Cost and Qty are inputed by the user, please advise why should I create a formula to compute Unit Cost again ?.
Thank you
Tracy
Date: Sat, 3 Dec 2011 05:18:16 0500
From: qliktech@sgaur.hosted.jivesoftware.com
QlikCommunity
Re: Partial Sum created by Sridhar Ethiraj in Development (QlikView Desktop)  View the full discussion
You can use this below formulae to calculate Total Unit Cost
sum((Cost*Qty))/sum(Qty)
Sridhar
Reply to this message by replying to this email or go to the message on QlikCommunity
Start a new discussion in Development (QlikView Desktop) by email or at QlikCommunity
© 19932011 QlikTech International AB Copyright & Trademarks  Privacy  Terms of Use  Software EULA


