Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Getting Null values from Multi Row Formula tool

Highlighted
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
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