Summing of formula field

[Barbara265]

I have a formula that calculates annual salary for each employee within a department. My report is grouped by department and I need to be able to add up the salaries for all the employees within a department for a department salary total. Crystal help suggests that you can sum a formula field, but when I select the salary formula field, the "Summary" option from the Insert menu is unavailable.

Any help will be gratefully appreciated!

[sig][/sig]

 

[kenhamady]

please post the formula used to calculate the annual salary. You are probably trying to do a sum of a sum. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[Barbara265]

Here's the formula...

if RecordNumber = 1 then
0
else
if ({EComp.EmFlxIDEb}) = Previous ({EComp.EmFlxIDEb}) then
Previous ({EComp.EmAnnual})
else
{EComp.EmAnnual}

I'm reporting off a Source 550 database running on SQL 7.0. I didn't develop this formula, but borrowed it from another report. This field and the others I'm reporting on appear in Group Footer 2. Everything but totaling the annual salary works! Thanks for your help Ken. [sig][/sig]