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

Sum for 12 months in member formulas

in Financial Consolidation and Close 5 comments

Summary:

Assistance Required: Dynamic 12-Month Summation Across Current and Prior Years in Member Formula

Content (please ensure you mask any confidential information):

We are trying to achieve the following requirement through a member formula:

  • Sum for 12 months of A
  • Sum for 12 months of B
  • Calculation: A/B * 15

In the example below, we have taken July 2024 as the current period. It needs to calculate the sum from the prior year, August 2023 to July 2024, to get the 12-month total. If we change the period to August 2024, it should dynamically adjust to sum from September 2023 to August 2024.

Can this be achieved through a member formula or a business rule? If so, could you please provide some suggestions?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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