L1MB 9.2.5

rgarg25
Occasional Contributor

L1MB 9.2.5

Hi Anaplanners,

 

I'm getting attached error while using formula to populate my module.

Can someone please help me.

1 ACCEPTED SOLUTION

Accepted Solutions
rgarg25
Occasional Contributor

Re: L1MB 9.2.5

It has been solved. I just pivot the dimensions in SYS04 and SYS06 modules.

Thanks

View solution in original post

5 REPLIES 5
MarkWarren
Expert

Re: L1MB 9.2.5

The formula looks correct, but I would try pointing to the line items rather than typing, just to be sure the item names are correct. Apologies if you have tried this!
rgarg25
Occasional Contributor

Re: L1MB 9.2.5

I've tried out pointing to the line items as well but still it's giving me an error.
MarkWarren
Expert

Re: L1MB 9.2.5

Could you paste the formula you have?
Here's my version for comparison:

'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]
rgarg25
Occasional Contributor

Re: L1MB 9.2.5

It has been solved. I just pivot the dimensions in SYS04 and SYS06 modules.

Thanks

View solution in original post

MarkWarren
Expert

Re: L1MB 9.2.5

I should have asked to see the sources first!
Excellent, well done for working through that, good luck with the rest!