Create some sample workbook with your expectations.
Attached is an example of part of the data as well as a column that would show the expected result I want to achieve.
The pseudo code would look something like:
THEN DATEDIFF('seconds', [BatchEndTime], Previous non-null BatchStartTime)
My problem is that I don't know how to reference the last BatchStartTime.
ExampleWorkbook.twbx 10.2 KB
Can you also help me. I have kind of same query.
Here I have Invoice and corresponding action dates.
I need to count all business days took to complete the invoice like:- business days comes in first action day till last action day for a particular invoice.
I also need to exclude holidays as provided
Thanks for help in advance.