Quarter value of forecast for the Qtr in which switchover occurs

What are the alternative workarounds for this?
When getting data from a line item Forecast version for a Quarter in which switchover occurs during the quarter, the QUARTERVALUE or [Lookup: <quarter>] return a value that only includes the Actuals amount for the month before the switchover date. (see screenshot)

Forecast_QUARTERVALUE_screenshot_147496.png

Accepted answers

All comments

rob_marshall

@hendersonmj

Try turning switchover off for the line item. Also, Quartervalue() will perform better than the lookup.

Aaron325

I have faced the same issue. Can anyone help me?

greatpeople me kroger schedule

Aaron325

I have faced the same issue. Can anyone help me?

Anren

Read the answer higher.

ManjunathKN

Hi @hendersonmj

Since your Switchover Month is Aug, until july it is actuals and from Aug it is rolling forecast. your total value for Quarter will be only 7 i.e, july. And if you go to Sept it will be july+Aug. so when you do lookup you will only get the Actuals quarter value.

you can use quartervalue for months after switchover with some if else formula. Else you can simply bring Quartervalue formula across. Quartervalue bring the quarter total into months.

Thanks,
Manjunath

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Python API SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…