Number Sorting - Greater than Next line

anitamarie2020

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

Alertyx Query - Line Items.xlsx

mceleavey

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.