Syntax Help

[jumpy262000]

I'm trying to count the number of records between a value of work days.

For example I have three columns

Work Days, Keyrec, Status
3 1235 Active
2 1234 Active
2 1236 Active
2 1237 Active
0 1238 Active


I'm trying to create a summary in the report header that counts keyrecs between working days

Keyrec's between 0 to 2 days: 4

Keyrec's between 3 to 4: 1


I tried this formula
IF {iSeriesSQL_FADC_Unfinalized_Keyrec.KEYREC} in 0 to 2 Then
Count({@WorkDays} )
Else 0

The total so far is always 0.


@workdays is a concatginzed formula.

Open to any ideas!

[JaganEllis]

There might be a neater way, but you could try creating a read-time formula.
e.g.

whilereadingrecords;
numbervar ct;
if condition then ct := ct + 1;

and then a print-time formula to display the value

whileprintingrecords;
numbervar ct