3 Replies Latest reply: Aug 10, 2011 3:41 AM by mmichielin RSS

    Division of expression

      Hi, I'm not able to complete this simple task: build a new expression as a division of two existing progressive expressions.

       

      Suppose I have a table like this:

       

      Month     Amount     Margin

      1            300           12

      2            150           3

      3            220           45

       

      I need to calculate a column called "Progressive spread" equal to the progressive sum of Margin diveded by the progressive sum of Amount.

       

      The result should be:

       

      Month     Amount     Margin     Progressive amount          Progressive margin     Progressive spread (<= this is what I need)

      1            300           12            300                                 12                             12 / 300 = 4.00%

      2            150           3              300 + 150 = 450               12 + 3 = 15               15 / 450 = 3.33%

      3            220           45            300 + 150 + 220 = 670      12 + 3 + 45 = 60        60 / 670 = 8.96%

       

      I've tried every combination of progressive, sum total, sum above, ... but I wasn't able to achive the goal.

       

      Can someone help me?

       

      Thanks in advance

      Michele