Level 1 MB Lookup function issue

Vincent
Vincent
in Modeling

Dear,

 

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!

kr,

Vincent

 
 

 

Tagged:

Answers

  • Misbah
    Misbah

    @Vincent 

     

    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
    prabhu

    Hi @Vincent,

     

    You Formula is Correct.

     

    SYS04 Location Details don't have Time as Dimension.

     

    Capture.JPG

     

     

     

    and check other dimensions also.

     

     

    Thanks,

    Sorna Raja Prabhu

  • Misbah
    Misbah

    @Vincent 

     

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

Categories