Need to create a formula that compares values from details 1

[chrisgeek]

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?

 

[lbass]

if not onlastrecord and
{table.value} <> "0/10" and
datediff("n",{table.datetime},next({table.datetime}) < 90 then 1

...but I bet you are then going to want to summarize this, and you will have to use variables to do that.

-LB

 

[chrisgeek]

As always you are correct. Any hints on using the variables to summarize this. Working perfectly so far

 

[lbass]

//{@detail formula}:
Whileprintingrecords;
numbervar x := x + {@yourformula};

//{@displayresults} if summarizing at the group level, this belongs in the group footer; otherwise, in the report footer:
Whileprintingrecords;
numbervar x;

//{@reset} in the group header if summary is at the group level:
Whileprintingrecords;
numbervar x;
if not inrepeatedgroupheader then
x := 0;

-LB

 

[chrisgeek]

Thank you very much for your assistance I couldn't have done it without you.