Level 1 MB Lookup function issue

Highlighted
New Contributor

Level 1 MB Lookup function issue

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

 
 

 

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Level 1 MB Lookup function issue

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

Highlighted
Super Contributor

@Re: Level 1 MB Lookup function issue

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

Sorna Raja Prabhu
Highlighted
Master Anaplanner/Community Boss

Re: Level 1 MB Lookup function issue

@Vincent 

 

I think @Sorna Raja Prabhu  got it right. Your System module should not have time dimension.