Lookup based on a boolean line item
Hi, I have a target module INP01 with 5 dimensions (P1, C5, Size&BPC, Time, and Deal Levels) and I need to bring values from another module DAT05 which has 4 dimensions (P1, C3, Size&BPC and Time)
The point is that it needs to be done based on a boolean line item selected month? in DAT05 (which is true for the month selected in another module), bring the values into INP01.
I've tried using this formula: It returns: Level mismatch on common dimension
IF 'DAT05 Pricing Data in Representative and Size + BPC'.Selected Month? THEN 'DAT05 Pricing Data in Representative and Size + BPC'.FOB ELSE 0
I know both modules share P1, SizeBPC, for the customer family: C3(from DAT05) and C1 (INP01) but they don't share Deal Levels dimension that is in INP01 (Target).
Any idea on how to bring the values from DAT05 into INP01?