Skip to main content
Announcements
NEW Customer Portal: Initial launch will improve how you submit Support Cases. FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
daniel1017
Contributor II
Contributor II

Time Average doest not match

Hello Team, Im trying to get the average of time but when I try this formula it doesnt match with the avg of the excel file, do you know what is the problem? Here some examples.

daniel1017_0-1630434100531.png

daniel1017_1-1630434136214.png

Taking August month

On the excel file I have 00:00:24 of Avg but in QV it appears as 00:00:23, could someone can help me please?

The Expression that I-am using on QV is this one "Interval(Avg([Ch_AMS_K_ASA No Transfer]))"

Thank you so much for your help

 

Dan

1 Reply
sunny_talwar

Not entirely sure, but this could be because of Rounding Errors.

Community Browser