Had a Partner ask if there is anything that does a "last non zero value" like our first non zero. Discussed ranking, but apparently that wouldn't work.
The modeler can achieve the same effect with a simple formula. Imagine a numeric line item called Input. The last non-zero value (across a timescale, assuming that's the use case) can be computed for a line item Output using Output = IF Input <> 0 THEN Input ELSE PREVIOUS(Output)
We are writing from Centrify Solutions, an Enterprise Data Integration +AI company. We have developed a solution that integrates metadata from Anaplan and external sources like NetSuite into a virtual data warehouse. This creates a dynamic large language model that can be deployed internally to any data source or securely…
Hello Everyone, I’ve been using Anaplan CloudWorks, and honestly, it has completely transformed the way I handle daily integrations. What I love most is how simple it is — you don’t need deep technical knowledge to get started. It’s simple, user-friendly, and has become an essential part of my daily workflow. If you are…
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: In a working grid I click 'show/hide' and select 'Time'. My time hierarchy is FY > Half > Quarter > Month > Week. I want to display…
