Count of fields greater than value "x"

[d44]

I have created a report that has details on an applications.The fields are Application no, start date(d1), finalised date(d2), weeks elapsed(formula).

I created a formula(weeks elapsed) using Date Diff where

DateDiff ("w", {d1},{d2})

This works fine and give details of how many weeks that applications take to complete, ranging from 12-40 weeks.I am wanting to create an expression that gives me the Count of how many accounts that have taken more that 20 weeks to complete.

I have tried the count expression with the 'Weeks elapsed' and using >4 etc,but no success.


Thanks
Derek

 

[dgillz]

Insert, feild object, running total field, pick the field in question, evaluate based on a formula. In the formula put your logic for whatever "x" is. Finally, reset=never or reset=change of group, whichever is appropriate. Software Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Naith]

Have you tried:

whileprintingrecords;
numbervar counter;

if {@WeeksElapsed} > 20 then counter := counter + 1 else counter;

Naith

 

[d44]

re: Tried running total field.Worked great.

Thanks