count with conditions

[FrankInBerlin]

Hi everybody,

I have a grouped report and a formula calculating the days between to date fields. Now I want to count all records where the result of the formula is higher than x.

Group: Berlin
order1 1.1.02 30.01.02 diff:30days
order2 5.01.02 10.01.02 diff:5days
.
.
.
Group: Hamburg
order10 1.1.02 30.01.02 diff:30days
order20 5.01.02 10.01.02 diff:5days

So I need a formula counting all the orders with diff: greater 10days.

Any ideas?

Frank

 

[dgillz]

if {@DateDiffFormula} > 10 then 1 else 0

Then sum this formula. If you do not want the detail field to display just suppress it or delete it, the sum will still give you a good count. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[FrankInBerlin]

Works perfect!

Thankx from Germany

Frank