can someone tell the exact problem in the formula
@Nehal1511
Looking at the error it seems that you have not created 'Unit Price %' line item in the REV04 Price Growth Rate Module.
Also check the second Lookup that you have applied, try to match it with the second screenshot that you have attached.
It will then work
~Anand
Don't copy paste the formula. Try to refer the line items
Its REV04 and not REVO4. Kindly get a clarity whether it's 'Zero' or 'Alphabet O'
Attach the screenshot of the error, the line item that you have created in the module and the dimensions(blueprint view).
There is a space between 'Unit Price' and '%' in the formula. BUt the same is missing in the module that you have created.
A free advice: It will be a good idea to use Snipping Tool that is provided by windows.
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
