Hi, would like to ask on how can show the escalation yearly amount? for example FY21, the amount is 10M and for FY22 the amount should be 10M x 1.1 = 11M. Please see screenshots below. Thank you
anaplan
excel: should be amount
Try this instead, in the Escalation line item:IF ITEM(Time) = Time.'FY21' THEN Calc Yearly Amount - Calculate ELSE PREVIOUS(Calc Year Amount - Escalation) * 1.1If this works, replace the hardcoding of Time.'FY21' to a lookupRegards,Anirudh
hi anirudh,
its the same figure i got. please see ss below. thank you
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
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.…