3 Replies Latest reply: Nov 7, 2017 4:55 AM by Philippe BONNIN RSS

    If(dimensionality () = 0 & 1 ?

    Philippe BONNIN

      Hi everybody

       

      i have a PIVOT TAB like this

       

      PIVOT.png

      I created Aggr expressions with ratios and i use IF( dimensionality () for TOTAL and SUBTOTAL calculations like this

       

      If(Dimensionality() = 0,

      Sum(Aggr( .....

      If(Dimensionality() = 1,

      Sum(Aggr(....,

       

      it's working perfectly, but i think it's a too complicated syntax

       

       

      Is there a syntax that alows me to write only one time the expression (as the fonction "OR" in excel) ?

       

      like this :

       

      If(Dimensionality() = 0, OR 1,

      Sum ( Aggr( ...

       

       

       

      Regards

       

      Philippe