In my details section I have a number of claim numbers, some of which are duplicated, some are not as well as 2 dates and I have a formula determining working days.
However when I run an average it averages all the working days but I want it to average the working days distinctly on the claim number, therefore giving me only one working day figure per claim instead of 3 for some, 1 for others etc etc.
Is this possible....please.....anyone?
However when I run an average it averages all the working days but I want it to average the working days distinctly on the claim number, therefore giving me only one working day figure per claim instead of 3 for some, 1 for others etc etc.
Is this possible....please.....anyone?