L1MB 9.2.5

[rgarg25]

Hi Anaplanners,

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

Can someone please help me.

[MarkWarren]

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]

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

[MarkWarren]

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 · Accepted solution]

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

Thanks

[MarkWarren]

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

[jpazdernik]

Did you remove time from the SYSO4 module?