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

    Partial Sum

    Tracy Crown

      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
          Sridhar Ethiraj

          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

              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

              To: tracycrown@hotmail.com

              Subject: - Re: Partial Sum

               

               

               

               

               

               

               

               

               

               

               

              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

              © 1993-2011 QlikTech International AB     Copyright & Trademarks | Privacy | Terms of Use | Software EULA

                • Re: Partial Sum
                  Sridhar Ethiraj

                  You can use this below formulae to calculate Total Unit Cost

                   

                  sum(Cost*Qty)/sum(Qty)

                   

                  -Sridhar

                    • Re: Partial Sum
                      Tracy Crown

                      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

                      To: tracycrown@hotmail.com

                      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

                      © 1993-2011 QlikTech International AB     Copyright & Trademarks | Privacy | Terms of Use | Software EULA