INITIAL VALUE OR APP FORMULA

[bolognesiedalla]

hello everyone I am faced with this situation:
a column with INITIAL VALUE formula allows the user to modify the proposed value. However, if you want to edit the record, when you change other values to which the formula refers, it does not perform the automatic recalculation. I could put the formula in the APP FORMULA , but then it doesn't allow manual editing. Is it possible, in some way, to have both the automatic recalculation and the manual modification?

this is the formula

SUM(
SELECT(
TERRENI[SUP. (ha)],
IN([ID_TERRENO],[_THISROW].[APPEZZAMENTO] )
)
)

[Joseph_Seddik · Accepted solution]

Enable the option Reset on Edit. That should give the desired behavior. 

[bolognesiedalla]

Thank you so much. I had missed this option to activate