About Axel_H

Timesum formula currently works with time periods. When the granularity of the data is Days, the formula cannot return anything (although it does not generate an error). The idea here is to enable Timesum to also work with Dates so that we can apply this formula to more granular use cases. ... View more

Sometimes we have a list in which some list items should be populated via a formula and some other list items via a manual input. The way to model this at the moment is to create 2 line items enabling to input first and see the final amount that takes into account the formula. Obviously, from an end-user perspective, this is hard to sell to anyone new to Anaplan. I think it would be great to have a Formula Access Driver in the same way that there are Read/Write access drivers. The Formula Access Driver would be a field in the blueprint where you could reference a boolean like the R/W access drivers. It would then have the following effect: if true then the formula apply, if false, then it does not and a manual input is needed. This would enable to have the functionality described above. @usman.zia ... View more

The hierarchy view for the workspace admin is very useful but unfortunatley we cannot produce a graph that replicates this functionality for the end users. As partners, we've been regularly asked by our clients to provide more graph related views of the underlying structure and data. The idea of such a graph would be that you generate a hierarchy graph based on a defined list in a module that utilises the list hierarchy as the graph structure. You can then use any line item to populate the values in the different boxes. I have loaded an example as an attachement. In this example, the line item chosen to display in the boxes is just the item name. ... View more

Monte Carlo method is an algorithmic technique used to understand the impact of the variability of a set of drivers in a forecasting model, using a probabilistic approach. It is widely used in environments where the number of drivers involved and their volatility is high and documented, especially in market finance. It would be great if we could assign a probability law to a set of drivers in Anaplan and launch such simulation. The simulation would assign a random value for each of the drivers selected, following the distribution of the law selected, and would result in a result table dimensionned by these drivers. ... View more