Using a Count in a Formula 1

[BlushingFBM]

Hello,

I have a report that is grouped by username and counts the items for each username.

I want to use the count # in a formula like:

If {USERS.USERNAME} = "jsmith" then {count}/9 else 0

The only problem is I don't see {count} listed in the Report Fields.

Thanks.

 

[Madawc]

You could do [CountSmiths code]If {USERS.USERNAME} = "jsmith" then 1 else 0[/code]
You could then do a summary count of @CountSmiths. Or you could do a running total.

The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Madawc]

Sorry, that should be

You could do

If {USERS.USERNAME} = "jsmith" then 1 else 0

You could then do a summary count of @CountSmiths. Or you could do a running total.

The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[BlushingFBM]

Madawc,

Thanks so much ... greatly appreciated.