4 Replies Latest reply: Dec 3, 2011 10:52 AM by Tracy Crown

# Partial Sum

Dear all

The Total in Unit Cost (\$327) and Amounts columns (\$20,928) are incorrect, need your help to advise how to compute the Average Unit Cost and Total Amount ?.

Thank you

Tracy.

• ###### Partial Sum

Hi,

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

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

Subject: - Re: Partial Sum

QlikCommunity

Re: Partial Sum created by Sridhar Ethiraj in Development (QlikView Desktop) - View the full discussion

Hi,

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

• ###### Re: Partial Sum

You can use this below formulae to calculate Total Unit Cost

sum(Cost*Qty)/sum(Qty)

-Sridhar

• ###### Re: Partial Sum

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

Subject: - Re: Partial Sum

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