Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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