Hi,

Locking a formula and having different formulas for different versions is not the same thing. What are you trying to achieve ?

Hi Nathan, 

I am trying to lock formulas for different versions. Is scenarios going to be the best option here or should I use a version dimension list to do this task?

Thank you

Formulas are never locked. The admin/builder can always modify them. 

Only the snapshot is frozen

Hi,

To add more on the top of Nathan’s answer, in Pigment, you can indeed create different versions of your forecast using the Scenarios feature. Each scenario can have its own set of formulas, allowing you to model different versions of your forecast. However, there isn't a feature to lock formulas specifically within scenarios.

If you want to prevent changes to the structure of your application, including formulas, you can use the App Lock feature. When the application is locked, members can't update formulas. However, they can still create, update, and delete Views & Boards, create and rename scenarios, perform manual inputs, trigger CSV and connector imports, and more.

Please note that the App Lock feature locks the entire application, not just specific scenarios or formulas.

Related Documentation:

Secure Your Pigment Application with App Lock
 

Hey, 
If I understood correctly you have the following case:

• There is a metric, let’s call it “Metric_Current”, which has a formula of  “A * B”
• You are want to consider a scenario where this formula would be changed to “A * C”, which would mean that the values would change for all versions. 

One thing you could do is create a new metric, let’s call it “Metric_Frozen”, where you import figures from “Metric_Current”. This means that the values are frozen. 

You can then update the formula in “Metric_Current” to be “IF(Version = Version.X, Metric_Frozen, A*C)

Now your values for a certain version would be frozen. You can save the import configuration and publish it to a dashboard for easy use. 

I have used this method for some final reports where I have wanted to lock budget figures in case formulas are changed at some point of the year. This method allows building comparison reports between versions, but you will not be able to drilldown to every detailed calculation.