Alteryx Designer Discussions

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

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?

 

Thanks,

Harshad

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!

Leigh

8 - Asteroid

Hi Leigh,

Thanks.

This works!

Alteryx Partner

 

Hi Harshad

 

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

 

 

clipboard_image_0.png

Labels