Alteryx Designer Discussions

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

Getting Null values from Multi Row Formula tool

8 - Asteroid

Hi All,

I am getting null values when I use the Multi Row formula tool.

Essentially, I want to a cumulative of the second column and the previous row of the 3rd column; Grouped by Trip Number. I am getting null values i.e. no output. Seems pretty simple but I am stuck.

Can anybody please help?




Alteryx Certified Partner

Hi Harshad, 


Solution is attached.


When adding a null value to an integer, the result will become null. To avoid this, I have set all null values to equal 0 prior to generating the cumulative columns. The resulting formula is:


IIF(isnull([LEG_TM_SCHED]), 0,[LEG_TM_SCHED])  
IIF(isnull([Row-1:CML_LEG_TM_SCHED]), 0, [Row-1:CML_LEG_TM_SCHED])


Hope this helps!


8 - Asteroid

Hi Leigh,


This works!

Alteryx Partner


Hi Harshad


If you change the NULLS to zero your workflow produces the answer you appear to be looking for.