Count not returning correct answer 1

[sprog]

Hi there
I have written a very simple report listing total staff and if they are full time or part time.

My 2 formulas are:
if {Employee.HoursPerPeriod} >= 60 then "Full Time" and
if {Employee.HoursPerPeriod} < 60 then "Part Time"

I need to calculate percentage of Full & Part time. When I use the count function it is returning the total number of staff, rather than just the number of full and then part time.

Any suggestions would be appreciated.
Thanks Julie

 

[Turkbear]

Hi,
Add 2 formulas to do the counting:
{?IsFullTime}
If {Employee.HoursPerPeriod} >= 60 then 1 else 0

{?IspartTime}
{Employee.HoursPerPeriod}< 60 then 1 else 0

Place these in the details section ( you can supress their display) and SUM then to get 2 counts...go from there...



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[sprog]

Thank you very much. This worked perfectly!
Julie

 

[Turkbear]

Hi,
Glad to help..






To Paraphrase:"The Help you get is proportional to the Help you give.."