Hi,
Just wondering if anyone could suggest a formula.
I was to check and make sure that no line amount is less that the number beforehand,
For example - in row 4 I want to ensure that the number in row 3 is not greater than the number in row 4.
Thanks,
Anita
Solved! Go to Solution.
Hi @anitamarie2020 ,
Welcome to the crazy world of multi-row formulae!
Use hte multi-row tool with the following formula:
if [Row-1:HWM] >[HWM] then "Fail" else "Pass" endif
Hope this helps.
M.
Thank you so much 🙂 That worked perfectly