Formula Help

[Deleco]

Hi All,

Im a bit stuck and need help with a formula, let me explain.

Below is the data

GH	Dean	Full Time	
D			Gardner
D			Carpenter
D			Carpenter
D			Carpenter
D			Plumber

What i need is to set a formula to put in the group header, if in any of the details there is Carpenter then i want the formula to equal 1 else i want the formula to equal 2.

It sounds straight forward but i am having real problems with this on.

Any help would be appreciated

Deleco

 

[mbarron]

Create two formulas.

This one goes in the detail section and is then suppressed.
{@carpenter}
if {your.field}="Carpenter" then 1 else 0

This one goes in the Group Header
if sum(@carpenter},{your.group})>0 then 1 else 2


Mike

 

[Deleco]

Thanks very much. Worked a treat!

Now i have to use this data in a crosstab in another report, wish me luck!! ;-)



Deleco