Hello,
I am writing a report and need to create some statistics. The report is showing findings that can be anywhere from "0/10" - "10/10" and can be returned in any frequency or order. For example The results might be 10/10, 10/10, 0/10, 5/10, 10/10. I would like to be able to say if the value is anything other than 0/10 is the next value within 90 minutes (comparing the time/date entered fields). If so then 1 else 0. Any ideas on how I could do this?
I am writing a report and need to create some statistics. The report is showing findings that can be anywhere from "0/10" - "10/10" and can be returned in any frequency or order. For example The results might be 10/10, 10/10, 0/10, 5/10, 10/10. I would like to be able to say if the value is anything other than 0/10 is the next value within 90 minutes (comparing the time/date entered fields). If so then 1 else 0. Any ideas on how I could do this?