Check if a row in a column contains a value less than zero so enter a value in another column in the same row value 2010 I want to do this by query

Check if a row in a column contains a value less than zero so enter a value in another column in the same row value 2010 I want to do this by query

Please!!!

Hi @tamar.m

U mean by linq query?

yes
thank u

How to use table filtering I want to check if a row in the table is equal to a certain value then enter number 2010 in another column will enter another number
For example:
If the Amount
Is smaller than zero so it will fit into another column in table number 2010

Amount
-200.00
352,000.00
8,460.00
42,742.00
-2,265.81
Filter column SAP code for value = 2010.
Then also filter value in column ‘Business type’ with the following values:
av
acv
jjjd
For all the lines which remain after this filter, change the value in column SAP code to 8001 (instead of 2010 which was there before the change).