Is there any way to have the last item of the waterfall be a running total that starts from 0 and shows the net of the previous waterfall components? I'm using line items here, would just want the Ending NAV to always start at 0
Hi @mwu214 , What do you mean by always start at 0? Do you want that bar to show the result of 0+126-93?
Hi @devrathahuja , sorry for the confusion - to clarify:
I meant 0 as in the last waterfall field (ending NAV in this case) should be a cumulative bar/total of the previous components and start from 0 on the y-axis, as opposed to starting at 33 like it is now.
Would look something like this
@mwu214 - Got it, can you share the blueprint view of the module? Seems like the parent-child relation is not being recognized in this case.
@devrathahuja apologies, don't think I'll be able to share blueprint view but I see your point now - so this waterfall view can only aggregate the last field the way I want it to IF there is a proper parent/child relation between that field & the rest of the fields that should add up to it?
Will need to find a way to establish that type of relationship between line items vs. list dimension
@mwu214 - Yes that is correct. It needs A+B+C=Final line for it to work. It can be set up as a list or as line items, either way.
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…
