Omit zeros when averaging numbers

[deborahyr]

Using Crystal 11, I'm creating a age field if employee is an incumbent in a position.

if (field) = "incumbent" then 1 else 0
if (incumbent) = 1 then (age) else 0

in the report footer, I wanted to add summaries for average age by category. using example above, how do I get it not to count 0's and just average those identified with an age as above?

category age
incumbent 45
talent 0
incumbent 42
talent 0
talent 0
my average for incumbent should = 43.5 not 17.4
Help!!!

 

[mocgp]

Insert a Running Total for Average, and in the Evaluate section, check "Use a formula", open the X-2 box and type in {@age}>0.

 

[deborahyr]

Thanks for the quick response. In the meantime, I tried another trick.

Running total - summarized (age)field, average
evaluated using formula - (incumbent field) = 1
Never reset

it worked!

 

[deborahyr]

to piggyback this, how do i show this in a stacked bar chart?

incumbent avg age
incumbent avg tenure

using these running totals fields from my report footer

 

[Madawc]

Have you tried Insert > Chart? It does most of the work for you.

If there's still a problem, please start a new thread for a new topic.

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