Hi all,
Is there any possibility for manually entering and using formula in same line item...
Knowing its not possible still is there any possibility for the same ....
Regards,
JEEVAK
Hello Jeevak,
Once you add a formula, it would not be generally possible to input a number. There are ways around though, as you could have 3 line items following the next criteria:
Hope that is helpful!
Short answer is no, you cannot have one row/column that is both editable and formula driven.The only time you can do that is by using versions and restricting the scope of formula from within the blueprint. This restricts the formula to certain versions and other versions are editable but again, this isn't one row/column
If you are using Versions in your model, you can leverage the Formula Scope functionality to have a formula apply to a specific version, and then leave the formula blank for another version. You would typically use this approach if you are doing something like importing actuals, but using a formula to generate a forecast.
If you are looking to allow users to override a formula-driven value, then you would configure the model per @Bruno's suggestion. You can also view a microlesson from Level 2 Model Building on configuring a model to allow overrides: How to Adjust or Override a Previously Calculated Value (3 min).
Hi @JEEVAK
Essentially if you are using a formula for line item , you would not be able to manually input values , however if your module uses native versions , there is a possibility that the formula can be restricted to be applied to only particular versions (Actual , or current ) etc. Meaning that for the other versions where scope is not applicable , values can be entered manually
Hi everyone, I'm trying to use this function on specific members of my grid, as described in the documentation. In my example, the grid contains two row elements: ACTIF and PASSIF. The problem is that when I use this function, it affects all elements in the grid, whereas I only want it to apply to the specified member:…
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
