Hi Dennis,

Yes, Calculated columns are indeed stored on the database and do require an upgrade after changing.

Reason the fields is mutable here is that expression fields are no problem to change.

Hi Mark, 

That expression fields are modifiable in subjects I understand. However, the column "pallet_price_1_incl_diesel" is not an expression field but a calculated column. Wouldn't it make more sense that this is only modifiable in the data model so that the SF recognizes this as a model change and picks it up with this in the upgrade script? 

Hey Dennis,

That would indeed be a great solution, but sadly we currently cannot make this query read only only on this screen for a specific Calculation type. That would require some additional model objects just to let the Layout procedure know when to make this query field read only.

An alternative could be that this screen prevents an update of the query in all cases, so no matter which Calculation type is chosen, the query cannot be edited here. I'll discuss this with the team to see what would be a suiting solution.

I am curious about the outcome. I especially wanted to make sure I understood the operation of calculated columns correctly.

Discussed it a bit, it seems that this was a result of allowing Column configuration changes inside the Subjects screen. As this field is more Data model than GUI, we'll make the query field read only for this screen for the 2023.2 release.