Hello everyone,
I have a simple question for you, I would like to build the following query using formulas in JMP if possible:
Put in the "error" column the value 1 one line after a cell in the "balance" column is non-zero.
Here is the database:

Line 38,061 should have the value in the "balance sheet" column be 1 and line 38,060 not.
Thank you for your answers !