SAC - Create Date Variance Calculation

[#1]

Hello everyone,

I was wondering if there is a way to calculate a time variance that is dynamically created for each time period.

February Value = Original Feb Value - Original Jan Value

March Value = Original March Value - Original Feb Value

I could only find the Lookup function, this however, allows me only to choose a specific month and not iterate it over each month.

Some help or advises from your side would be highly appreciated.

Best regards

[jonasvorwerg]

Hi william.yu

I think this does not solve the problem. I need more something like a cumulated sum.