Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Number Sorting - Greater than Next line

anitamarie2020
8 - Asteroid

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

4 REPLIES 4
mceleavey
17 - Castor
17 - Castor

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.



Bulien

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

You need to use multi-row formula.

 

Please see my workflow that is attached. 

anitamarie2020
8 - Asteroid

Thank you so much 🙂 That worked perfectly 

mceleavey
17 - Castor
17 - Castor

no problem.gif



Bulien

Labels