How to implement a multiple-criteria-mapping into a formula

Options
LucaRicci
LucaRicci
edited September 2023 in Modeling

Hi,

I am trying to make this mapping work in the best way possible.

I have 3 criterias: RV1 Revenue, RV3 Revenue, Product Class.

image.png

I need to have, as a final outcome, the same Revenue BU of the mapping in this final module:

image.png

How can I achieve this? Is the IF THEN ELSE concatenation the only solution possible?

Thanks,

Luca

Tagged:

Answers

  • CommunityMember121571
    CommunityMember121571
    Options

    Hi Luca,


    Is it correctly understood that you have 3 criterias, which combination used to map 4th one?

    Mapping example.jpg

    If so, you should create mapping module, something like
    Dimensions: RV1 Revenue, RV3 Revenue, Product Class
    Line item: Revenue BU

    You could fill mapping directly there or could calculate it referring to your REV03 input mapping module (I would recommend to think about duplicate lines in advance).

    Since you have mapping module you can in Dat11 directly lookup from mapping module using line items from DAT11

    Something like Revenue BU = Mapping Module.Revenue BU[lookup:RV1 Revenue, lookup:RV3 Revenue, lookup:Product Class]

    Best,

    Konstantin

Categories