Forum Discussion
bcampbell
Helper I
Helper IAverage Times when there is blank / no data
Good Day, I could nee some assistance on Average times from Data when I may not have a time entry For Example NUMBER CALL DISP CMPLT 1 13:48:32 13:50:44 14:09:55 2 10:01:01 ...
Hi bcampbell ,
You could do the subtraction calculation firstly. Then calculate the average with the filter of "DISP<>BLANK() and CMPLT<>BLANK()".
You could ignore the null value with this logic.
v-eachen-msft
Community Support
Community SupportHi bcampbell ,
You could do the subtraction calculation firstly. Then calculate the average with the filter of "DISP<>BLANK() and CMPLT<>BLANK()".
You could ignore the null value with this logic.