Section 6: Region Goal Set- Projected Goal

Cameron.Hill
Cameron.Hill
in Modeling

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. 

Tagged:

Answers

  • LipChean_Soh
    LipChean_Soh

    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

Categories