You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Rolling Sum in Member formula

Received Response


12 Months rolling sum to be calculated in member formula

Content (required):

Require a member formula that calculates the prior 12 months' value, Current month + previous 11 months.

Let's assume we are taking value from Account A and calculating the same in Account X(Dynamic Calc).

So far we have been able to achieve it using substitution variables and it works perfectly, except when we change the values of substitution variables. It overwrites the previously calculated value and replaces it with the current value for all prior months.

The logic we have built

This is expectation

This is what happening

When we move to next month

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!