Question on LOOKUP Function

Options
riteshshah
riteshshah Member, ALL USERS, Partner Posts: 2 New Contributor
in Planning & 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:

Comments

  • mburdak
    mburdak Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor

    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

     

  • riteshshah
    riteshshah Member, ALL USERS, Partner Posts: 2 New Contributor
    Makes sense, Thanks for reply.

Categories