How can I change a record to be ="current record value" + "value in another column"

[sales_bikefix]

I want to update the price value in a column by adding an amount to it.

[LeventK]

When do you want to do it? When adding a new record or editing an existing one?

[sales_bikefix]

Editing an existing.

[LeventK]

[Update that column’s value depending on a change in another column]

---

1.) Turn RESET ON EDIT property of the column that you want to edit/reset to ON
2.) Click on the blue funnel and record this expression:

AND(
    IN([KeyColumn], Tablename[KeyColumn]),
    LOOKUP([_THISROW].[ChangedColumn],"Tablename","LookupColumn","ChangedColumn")<>[ChangedColumn]
)

3.) Set an Initial Value expression to this column

IF(
    NOT(IN([KeyColumn], Tablename[KeyColumn])),YourDefaultNumber,
    YourDefaultNumber+[ColumnValueToAdd]
)

[sales_bikefix]

Presumably the default number can be zero?

[LeventK]

Default number can be any number including zero

[sales_bikefix]

Small problem - the lookup column could be one of three - “paid cash”, “paid card” or “paid transfer”. I was trying to do it from three different action buttons. Is that possible?

[sales_bikefix]

Its an “amount due” field and I currently have it as [Total Service]+[Total Parts]+[Shop Sale]-[Card Paid]-[Cash Paid]-[Transfer Paid] but obviously the logic doesn’t work if I then add another cost.