HELP! PLEASE! NEED DELETE ROW AND SUBTRACT VALUE IN ROW BEFORE

[GS87]

I need to create an action that when deleting a row, a value "x" is subtracted from the value of the previous row. My problem is for the syntax of selecting the row to which the action of subtracting the value is to be executed.

=select(TABLE[ID],AND([COLUMN]>[_THISROW].[COLUMN],[COLUMN2]=[_THISROW].[COLUMN2]))

What I did was generate 4 actions.

1. Delete row. The action groups two more actions 2 and 3

2. Select Rows. There I introduced the aforementioned syntax as a condition

2.1 Subtract value from column

3. Delete Row.

Well. I hope I have explained something to me and it is understood.

Thank's guys

[AleksiAlkio]

It sounds like you would need to use something like.. MAXROW("Table","Timestamp",[Timestamp]<[_THISROW].[Timestamp]) for reading the key value from the previous record based on a timestamp.

[GS87]

Thank you so much. In the end it helped me in the following way:

SELECT(TABLE[XXX1],AND([XXX2]>[_THISROW].[XXX2],AND([XXXXXX3]=[_THISROW].[XXXXX3],[XXXXXX4]=[_THISROW].[XXXX4])))

[AleksiAlkio]

Good to hear you were able to solve this.