Total newbie with Crystal Reports Formulas...

Hoping to get help with this..

 

Basically, I have a formula that looks like this:

 

Average ({tblEmployee_Team_Available_Hours.TotalProjectHours}) - Sum ({tblProject_Employee_TimeEstimates.Hours})
 / Count ({tblProject_Employee_TimeEstimates.Hours})

 

The only problem is that some of the records in {tblProject_Employee_TimeEstimates.Hours} are zeroes...I'd like to exclude those records...couldn't find anything similar to Excel's CountIF....

Please help....

1.variable formula to coniditionally count (lots of examples on this site)

or

2. a Running Total (RT) to coniditionally count

RT Name: NonZeroCount

Field to summarize={tblProject_Employee_TimeEstimates.Hours}

Type of Summary=Count

Evaluate=Use a formula...

reset=Never

 

(this must be used in the report footer since it is evaluating all rows).

 

3. if you have no duplicate records in the data set just use a formula to make a row =1 or 0 and then Sum that formula field

Name=RowCount

if {tblProject_Employee_TimeEstimates.Hours} = 0 then 0 else 1