LOOKUP MAPPING

Highlighted
Contributor

LOOKUP MAPPING

Hi,

For your assistance please. I created system mapping module for custom versions (List: Actual, Budget and Reforecast).

Scenario: I want to get the quantity difference of actual vs budget, in my Target module and I also included the custom verions in my applies to. I tried to lookup, apparently the values that I am getting is the actual data if it is actual and budget data if it is budget even if I included in my formula to subtract the two. Note that I did not used the Versions in the system, hence tried to created a custom version in the list.

 

target module

DMManalili_0-1601632977320.png

system module

DMManalili_1-1601633001684.png

Thank  you.

 

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: LOOKUP MAPPING

@DMManalili 

 

Assuming you want the result for actual to be zero, shouldn't the formula be:  Quantity[lookup: Test SYS Custom Versions.Actual] - Quantity

 

This should give you a zero for Actual because Actual Quantity - Actual Quantity is zero, but should give you 5000 for Budget.

 

Rob

Highlighted
Contributor

Re: LOOKUP MAPPING

thank you 🙂
Highlighted
Master Anaplanner/Community Boss

Re: LOOKUP MAPPING

Happy to help!