Working with Muli-Row formula unexpected result

[MartWClimber]

I'm working on a workflow that gives me a bit of insight into the time our workflows take to run.

all the data and stuff is extracted thanks to Alteryx but i run into a problem because I need to do some calculations now row by row but with multiple rows in mind.

When I use the multi row formula tool I was expecting an other output. 

Formula I use within the tool.

IF [WF] == [Row-1:WF] 

   THEN [Row-1:StartTime] 

   ELSE DateTimeadd([StartTime],[TimeDifferance],"Seconds")

ENDIF

I've attached a table below with the results I get when running the data via Alteryx and I calculated the the expected output via Excel to verify the output. 

I think my formula is wrong 

WF	Time	StartTime	TimeDifferance	StartTime Expected	StartTime before entering multi-row formula
Workflow1	0:01:12	16/07/2022 21:30:10	72	16/07/2022 21:30:10	16/07/2022 21:30:10
Workflow1	0:01:12	16/07/2022 21:30:10	72	16/07/2022 21:30:10	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Worklfow 12	0:00:13	16/07/2022 21:30:23	13	16/07/2022 21:49:32	16/07/2022 21:30:10
Worklfow 12	0:00:13	16/07/2022 21:30:23	13	16/07/2022 21:49:32	16/07/2022 21:30:10
Workflow 14	0:01:42	16/07/2022 21:31:52	102	16/07/2022 21:49:44	16/07/2022 21:30:10
Workflow 14	0:01:42	16/07/2022 21:31:52	102	16/07/2022 21:49:44	16/07/2022 21:30:10
Workflow 20	0:01:39	16/07/2022 21:31:49	99	16/07/2022 21:51:26	16/07/2022 21:30:10
Workflow 20	0:01:39	16/07/2022 21:31:49	99	16/07/2022 21:51:26	16/07/2022 21:30:10

[ChrisTX]

Can you post a screenshot of your Multi Row tool?  Did you check the box to group by WF?

Chris

[IraWatt]

Hey @MartWClimber,

First thing I did was convert your text Start Time to a date time using the Date Time Tool. Then I applied your formula to the new date time column:

This gave the correct results 2022-07-16 21:48:20 + 1080 seconds is 2022-07-16 22:06:30 not 16/07/2022 21:31:22.

Any questions or issues please ask :)
HTH!
Ira

[binuacs]

@MartWClimber one way of doing this using the DateTimeParse function

[MartWClimber]

I've updated the post with a screenshot. 

also I tried group by the WF but that didn't work :(

[MartWClimber]

@binuacs not quite because if you take a look at the new output (I think you created) I see that there is a row that contains that timestamp 21:31:22 that is correct in the sense that the starttime + 1:12 minutes equals this but the location is wrong. I would expect that timestamp to be in row 3 not in row 1 

[MartWClimber]

Hie @IraWatt  

in my Workflow the Starttime is already in Datetime format. 

even then I think that the new field you created don't match my outcome.

what it should do is see if WF column is equal to the current row. if that is so use the Starttime from the previous row.

if not it should add the time + the Starttime of the previous row.

[binuacs]

@MartWClimber Can you check the attached workflow now?

[IraWatt]

@MartWClimber the example data you gave is not in the Alteryx Date time format, Its text data.

Im confused by your first row how does a start time of 16/07/2022 21:30:23, with a duration of 13 seconds, get your result of 16/07/2022 21:49:32 ?