1 Reply Latest reply: Mar 21, 2013 12:59 PM by Nicole Smith RSS

    Rolling value but not

    Natalie Doswell
      Hi,
      I am looking to do something similar to the accumulation function. But instead of it calculating each row in turn and then adding it on, I would like it add up the total of each column and then calculate the ratio between amount and the paid.
      What Full accumulation gives me
      MonthAmountPaidRatio
      Jan101000.1
      Feb01000.1
      Mar1002000.6
      Expected result
      MonthAmountPaidRatio
      Jan101000.1
      Feb01000.05
      Mar1002000.275
      Thanks in advance