I am creating a report in crystal cross tab where i am displaying hourly average values like below:
However,there can be more than one value in an hour like for 7-8 it can have 2 values so i am calculating hourly average and it displays the average value for that hour.
Now, I want to calculate the maximum/minimum value of the populated average value how can we do that
could you please help me in solving this problem.
Thanks for your support and understanding!