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

[mceleavey · Accepted 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.

[Emil_Kos · Accepted solution]

Hi,

You need to use multi-row formula.

Please see my workflow that is attached. 

[anitamarie2020]

Thank you so much 🙂 That worked perfectly 

[mceleavey]