Level 1 MB Lookup function issue




I am trying to apply a lookup formula to retrieve data but I always get an error message that is not mentioning what is the error. I think my data should be ok, as well as the formula I entered but still I get error messages.


I attached the input of my formula and the error message i get.


Many thanks in advance!






  • Misbah



    Syntax looks perfect. Can you please check the name of your source module and line item. If you are mimicking the formula what is given by Anaplan you need to make sure that the name of the module and the name of line item is matching too.


    Check if your Source Module has the same name - REV04 Price Growth Rates

    Line item should be exactly Sales Price % and Cost Price %


    Hope you are not typing your formula, instead click and refer should be used .

  • prabhu

    Hi @Vincent,


    You Formula is Correct.


    SYS04 Location Details don't have Time as Dimension.






    and check other dimensions also.




    Sorna Raja Prabhu

  • Misbah



    I think @prabhu  got it right. Your System module should not have time dimension.