I wonder if some can give me a pointer.

 

I need to find the last date of last defect we finished on a project. We record all defects when we handover and we have a policy to close all defects within 10 days, so on my report I am showing handover date, counting number of defects and count number of defects over 10 days but on the same line they want to me to show the date of the last closed defect. I tried to write a formula but didn't work. Should I do a sub report and return the max value of the date?

 

Any pointer would be appreciate it.

 

Ta

Wessam