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

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…