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

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

Thanks

View solution in original post

6 REPLIES 6
MarkWarren
Expert

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

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

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

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

Thanks

MarkWarren
Expert

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

Did you remove time from the SYSO4 module?