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

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

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