topic Re: How to calculate turn around average for a 2 dates field in App Development

How to calculate turn around average for a 2 dates field

Ashwini_B — Thu, 27 Apr 2023 04:37:12 GMT

i have set of dates field and want to derive the average of the days. below is the set of values for the date field (ordered date and requisition date), I need the difference of the 2 dates (as shown below) and the average for the same.

[PO-P&I]Ordered Date (Date)	[REQ]Requisition Date (Date)	Diff
2/23/2021	1/14/2021	40
1/11/2022	1/10/2022	1
12/12/2022	12/1/2022	11
11/22/2021	11/18/2021	4
9/21/2022	9/5/2022	16
4/30/2021	4/26/2021	4
4/30/2021	4/26/2021	4
12/12/2022	12/5/2022	7
3/31/2020	3/30/2020	1

Re: How to calculate turn around average for a 2 dates field

Prem0212 — Thu, 27 Apr 2023 07:13:58 GMT

Can u please show me exactly what you are going to see the output???

Re: How to calculate turn around average for a 2 dates field

Chanty4u — Thu, 27 Apr 2023 17:43:32 GMT

// Load the data

Data:

LOAD [PO-P&I]OrderedDate,

[REQ]RequisitionDate,

Interval([PO-P&I]OrderedDate - [REQ]RequisitionDate, 'DD') as Diff;

// Calculate the average number of days

LET AvgDays = Avg(Diff);

// Display the result

Trace 'Average number of days: ' & AvgDays;