Alteryx Designer Desktop Discussions

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

Hi All,

Can someone help on the below Question?

If the of sum of 1st column less than 5th column i need 1st column as result. if the total utilized the remaining rows should be zero.

10 KB

2 REPLIES 2

Please retry your last sentence. Or punctuate it. Or both.

John Hollingsworth
Clear Channel Outdoor

Hi @Nelson_D - It's a good use case for an iterative macro, but also can be solved with a couple Multi Row Formulas:

Sum Previous Rows