Hi @ms2023 , when you open the Multi-row formula, you'll see in the middle of the configuration window three tabs: Variables, Functions and Saved Expressions. You can use Variables to point to your column values in previous rows. When you select a column in a previous row, it will appear this code in the expression window: [Row-1:Vendor Code] (if the column name is "Vendor Code"). You can just change the -1 to -2 or any other negative or positive number to point to any row in that column, or change the column name to point to any other variable.
In terms of changing the behavior of the expression, you can go to the Expression tab and select the function that suits your needs. If an "If-else" statement is what you need, when you click in the "Conditional" list, you'll see this expression: IF c THEN t ELSE f ENDIF.
Using these two tabs, you can build an expression like the following, that might help you:
IF [Row-1:Vendor Code]=[Vendor Code] AND [Row-2:Vendor Code]=[Vendor Code] THEN 1 ELSE 0 ENDIF
But to make this instruction work, you'll need to change the "Num Rows" at the top of the configuration window to 2, as it is only in 1 by default.
Just to remind you, you can also make these questions in Spanish if that's easier!
