4 Replies Latest reply: Aug 31, 2015 5:03 PM by Petter Skjolden RSS

    Help with aggr

    marcelo gonzalez

      Hi,

       

      I have a problem with the aggr function

      I have the following chart:

      aggr.png

       

      where

       

      DíasPagoPP =    (suM(ImportePago)/sum(total ImportePago)) * (only(FechaPago)-only(FechaPresentacion))

       

      I need a table only with the dimention: Mutual and the expresion DiasPagoPP

        

      MutualDiasPagoPP
      28 De Octubre128,11
      Mutual293
      Mutual363

       

       

      Any idea??

       

      Thanks!

        • Re: Help with aggr
          Rudolf Linder

          if you Need the other expressions for calcualting, you may hide These expressions

          (only possible if you use straight table)

          what is Mutual2 and Mutual3?

            • Re: Help with aggr
              marcelo gonzalez

              thanks Rudolf for your quickly response.

              I need to create a new chart only with de dimension Mutual and de expresion DiasPagoPP to compare  the "DiasPagoPP" by Mutual...

               

              Mutual2 and Mutual3 are fake names of Mutual. I used only as example.

               

              Thanks again

                • Re: Help with aggr
                  Rudolf Linder

                  I am not sure if I understood correct?

                  WHat if you define a new table (or Chart) just with the Dimension Mutual and the expression

                  DíasPagoPP =    (suM(ImportePago)/sum(total ImportePago)) * (only(FechaPago)-only(FechaPresentacion))

                  you should get 1 line for your example above with

                  MutualDiasPagoPP
                  28 De Octubre128,11

                   

                   

                  as Well as other "mutual values"

              • Re: Help with aggr
                Petter Skjolden

                Usually you wrap the expression in an Aggr and add the excluded dimensions into the Aggr() function as parameter 2, 3 and more if necessary.

                 

                Aggr( <your-aggregate-expression-goes-here> , Dimension2, Dimension3 , .... )