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, we need to bulk export approximately 150 customer Management Reports as PDFs each month from Anaplan. It involves selecting each customer from the context selector, exporting to pdf and then renaming the file. Currently this is a manual process. Has anyone implemented an automated solution to bulk export Management…
Hi, I'd like to know if my issue already occurred to anyone here. I created a saved view out of a module using different hierarchical lists. In the saved view, I pivoted the dimensions and restricted the view only on a specific line item. Then, I used that saved view to import data into another module however the data…
Hi, I have the following problem to solve and I’m not sure whether it’s even possible in Anaplan. I have List A with a certain number X of elements. For selected elements from List A, based on which I create a subset, I determine the components that make up each element. There can be a maximum of 6 components. Each line…
