Question on LOOKUP Function

riteshshah
riteshshah
in Modeling

Hello - I have a seemingly simple ask and need help. I have a module one DAT01 with two dimensions ( Country and Year ) and a line item Annual Percent Increase and I have another module, DAT02 with three dimensions Country, Product Family and Months. I want to reference Annual Percent Increase from DAT01 into DAT02. I am bit lost at how to use LOOKUP function since DAT01 doesn't have Product Family dimension and my formula is returning zeros.

 

Tagged:

Best Answer

  • mburdak
    mburdak
    Answer ✓

    Hi @riteshshah 

     

    There is a level mismatch on the Time Dimension, you need to use YEARVALUE() function to bring the yearly value to monthly level. 

     

    There is no lookup needed for Product Family.

     

    Regards,

    Mandeep

     

Answers

Categories