Section 6: Region Goal Set- Projected Goal

This seems to be a reoccurring topic. I also am only returning an answer of 0. My equation is Region Percent * Geo Goal Set.Projected Goal[LOOKUP: Parent]. I have also ensured my Forecast version is current as well.

Tags

Modeling

Calculation Functions

Accepted answers

All comments

Hi Cameron,

If Region Percent * Geo Goal Set.Projected Goal[LOOKUP: Parent] gives you 0, then at least 1 of the components is 0 or blank:

1. Region Percent

2. Geo Goal Set.Projected Goal

3. Parent

You can use the 'Drilldown' feature of Anaplan to find out which is 0 or blank, and proceed from there.

Thanks,

LipChean

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…