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
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
