Level 2 Sprint 2 DEM03 Growth Rate % line Item

Options
Joh04924
Joh04924 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

 

For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mapping reference:

Screen Shot 2020-06-30 at 4.41.32 PM.png

The issue I am having is that I am unable to properly map the formula. Resulting in various error messages.

I have been using variation of LOOKUP, and LOOKUP & SELECT functions, to no avail.

Comments

  • Joh04924
    Joh04924 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    Thank you! 

  • Evahong
    Evahong Member, ALL USERS Posts: 5 Occasional Contributor

    I have this problem too. Anaplan shows level mismatch on common dimension (attached screenshot). Are we missing on another dimension?