Forum Discussion
Average Duration Returns Incorrect Results
You get extra points for showing your work. However, as you have mentioned - no sample data = no help . You will have to find a way to produce sample data that fully covers your issue (including the overflows etc. ) .
The issue itself seems solvable although it is definitely smelly - how can you guarantee that all your users are fully aware of the different computation for P1 and P2 versus P3 to P5 ? Seems to be ripe for misinterpretation.
I was hoping someone could look at my formulas and point out an error. I don't even know how I could post sample data... I've always done it by embedding a table directly into the question, and there are too many rows for that. Security restrictions prevent me from uploading to a file sharing service.
As far as confusion over the different computations - the audience of this data is the folks who work the tickets. They are fully aware of the different ways it's calculated. I have no concerns in this area.