L1MB 9.2.5

rgarg25

Hi Anaplanners,

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

Can someone please help me.

Screen_Shot_2021-02-10_at_3_97363.png

Comments

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

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?

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…