8 Replies Latest reply: Jul 9, 2014 2:53 AM by Joaqu�n L�zaro RSS

    Dealing %

    Joaqu�n L�zaro

      Hello:

       

      I have an expression to calculate the % of a total, I need a second expression that accumulate he previous % ... but I'm not able to write it.

       

      Please, could you help me?

       

      This is the expression

       

      NUM( 100 *

            SUM( Sales )       

          / SUM( TOTAL Sales)        

          , $(NumberFormat2Dec), DecimalSep, ThousandSep)

       

      And this is the table that i can't get

      Image1.PNG.png

      Which expression i need write in column 2 ??

       

      Thank you very much,

      Joaquín