Hi Community
I have included the formula as requested into the formula line of Revenue however it's giving me the attached ERROR MESSAGE which I can't seem to rectify. Any assistance regarding this would be greatly appreciated.
regards
Hi @NathanMay
Here in this for Revenue is 'REV02...'.Volume * 'REV01...'.Sales Price *(1 + Sales Price Growth %)
Here Sales price is increasing and is shown in Sales Price growth . So we need to capture Revenue with Sales Price Growth % .
Invalid error here may be because of some manual errors while selecting line items .
Hope the above condition helps you to solve this.
Thanks,
Puneeth HP
I am also having the same issue and not able to fix it. i selected my line items very well yet, i am not able to put in the formula for revenue and cost of sales. Can you please help ?
Hello,
I've tried that formula you stated above, and it still does not work for me. Can someone assist me please.
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…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…