How can we do interpolation in Anaplan?
I need to interpolate scores from the following criterias:
a. Min number with equivalent score
b. Max number with equivalent score
Thank you!
@SarahE
It would be worth publishing a worked example of what you are trying to achieve.
I, for one, am not sure what Interpolation is!
David
Hi Sarah,
Could you please provide examples in Excel for both the criterias...
Thanks and regards,
Rashmi
Hi @SarahE - Is this what you were looking for? https://gaurav-dembla.medium.com/anaplan-use-case-4-linear-interpolation-3d28b03987f8
Interpolation: You make 5k in a month, but is so far the 3rd week of the month, how much you have earned on a weekly basis? Since is 3 of 4 weeks, you have ~ 3/4 of 5k. That's a Linear interpolation or [InitialValue + (Days) x (FinalValue - InitialVaue)/(FinalDate - InitialDate)] or [ 0 x 21days x (5k -0)/(30days - 0) Let you calc things like the %of budget you should have cover by an specific date or Accrued costs, etc
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…
