Question on LOOKUP Function


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.


Best Answer

  • 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.