Formula Help

Hi,

Need help creating a formula that will look at LI for a rolling 5 day forecast and return back the max number of those 5 days. I set up a systems module that looks at the forecast for 5 days, and then tried to use it in the formula below.

Accepted answers

All comments

mburdak

Hi @neg177

To achieve this, you need to make a lineitem that only has values for the rolling 5 days. It's formula will be ' IF Rolling 5 days Forecast THEN Max cash demand ELSE 0'. The MAX of this lineitem will be your desired result, it can be achieved by setting the summary for this lineitem and MAX and referring the top level in the target lineitem.

Hope this helps.

Regards,

Mandeep

ravi

Please try the following formula.

TIMESUM('Rolling 5 day forecast', -4, 0, MAX)

rob_marshall

@ravi

Please do not use TIMESUM() with Time in the Applies as it can have performance issues:

ravi

@rob_marshall

Does this performance hit also apply to MOVINGSUM?

Can the following formula solve the problem without the performance hit?
MOVINGSUM(Line item, -4, 0, MAX)

rob_marshall

@ravi

No, MovingSum() does not have the same performance issues that TimeSum() does because MovingSum() was specifically made for line items with Time in the Applies To and TimeSum() was not. Here is a video which talks directly to that:

https://community.anaplan.com/t5/Anaplan-Live-December-2020/Function-vs-Function-MOVINGSUM-vs-TIMESUM/td-p/93488

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…