Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
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

Highlighted
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

Highlighted
8 - Asteroid

Hi Leigh,

Thanks.

This works!

Highlighted
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