2 Replies Latest reply: Jun 3, 2011 5:54 AM by Sravan Puppala RSS

    SetAnalysis and Aggr

    Sravan Puppala


      Hi,

       

      This is my Dimension

       

      DeliveryDocument_Key

       

      These are my expressions

       

      1st expression:

      sum(Aggr((Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]))* Range,DeliveryDocument_Key))

       

      2nd expression

       

      Sum(DeliveryQuantity/[ST/KAR1])

       

       

      Now these two work..

       

      what I need is  1st expression * (2nd expression pro DeliveryDocument_Key)

                            ----------------------------------------------

                             Sum(Total 2nd Expression)

       

       

      I wrote

       

       

      =sum(Aggr((Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]))* Range,DeliveryDocument_Key))Sum(Aggr(Sum(DeliveryQuantity/[ST/KAR1]),DeliveryDocument_Key))/ Sum(TOTAL Aggr(Sum(DeliveryQuantity/[ST/KAR1]),DeliveryDocument_Key))

       

       

      which does not give the result. How should I write?

       

      Thanks

      Sravan

        • SetAnalysis and Aggr

          Try this:

           

          =(((sum(Aggr((Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]))* Range,DeliveryDocument_Key)) )*  (Sum(Aggr(Sum(DeliveryQuantity/[ST/KAR1]),DeliveryDocument_Key))))/ Sum(TOTAL Aggr(Sum(DeliveryQuantity/[ST/KAR1]),DeliveryDocument_Key)))

           

          else upload ur application...

            • Re: SetAnalysis and Aggr
              Sravan Puppala

              Hi Erika,

               

              The basic trick in setanalysis is to test the parts individually, which I did not do before.

               

              This did the trick after individually checking the parts and adding AVG

               

              =AVG(Aggr((Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]))* Range,DeliveryDocument_Key)) *  Sum(Aggr(Sum(DeliveryQuantity/[ST/KAR1]),DeliveryDocument_Key))/ Sum(TOTAL Aggr(Sum(DeliveryQuantity/[ST/KAR1]),DeliveryDocument_Key))

               

               

              Thanks anyway

               

              Regards

              Sravan