We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Trying to find the Date Difference using the Multi-Row Formula

jeprime
8 - Asteroid

I am struggling to calculate the dates of service between two dates. While I believe there is something simple I am missing, it evades my comprehension. I am using the multi-row formula to attempt to calculate the datetime differences between two dates adjacent in the same column. My results is always null, and I cannot understand why. I even tried to just make a simple calculation for an end date using the formula function and then calculating the difference using the multi-formula tool - still results in null. Any help?

 

Workflow Example:

workflow example date diff.png

Workflow Input:

sample input.png

 

Workflow Results:

workflow results.png

11 REPLIES 11
jeprime
8 - Asteroid

I would use a data cleansing tool after the multi-row formula. It would change the nulls to zeros - see the attached image. 

LiliR
5 - Atom

Thank you. It worked!

Labels
Top Solution Authors