Former Member

# Need a count of ony lines without a value of 0.

Post Author: rconner

CA Forum: Formula

I am new to Crystal Reports and need a report that shows a count of employees by Job Type and Salary Range. I have a column defined for each Salary Range but if a salary for that Job Type and Salary Range is 0 it is included in the count. Below is an example of Job Type A805. Each Column represents a range of salaries. Column 1,2, & 3 Should have a count of 0. Column 4 a count of 1. Coulmn 5 a count of 8, etc.

Is there a way to do this? Thanks, Rick

A805

956063

A805

0.00

0.00

0.00

0.00

35,000.00

0.00

0.00

1553773

A805

0.00

0.00

0.00

0.00

35,000.16

0.00

0.00

1553779

A805

0.00

0.00

0.00

0.00

32,000.00

0.00

0.00

1556552

A805

0.00

0.00

0.00

0.00

35,000.00

0.00

0.00

1559128

A805

0.00

0.00

0.00

30,000.00

0.00

0.00

0.00

1559497

A805

0.00

0.00

0.00

0.00

35,000.00

0.00

0.00

1579256

A805

0.00

0.00

0.00

0.00

35,000.00

0.00

0.00

1613273

A805

0.00

0.00

0.00

0.00

40,000.00

0.00

0.00

1620184

A805

0.00

0.00

0.00

0.00

40,000.00

0.00

0.00

Count

9

9

9

9

9

9

9

10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on May 19, 2008 at 06:28 PM

Post Author: V361

CA Forum: Formula

If you are counting them, then you will get 9, you may need to select sum, if that is not what you want. You could use a running total, Field to summarize will be your column, type of summary will be count, Evaluate will be a formula, if = 0 then 0 else 1 any time the value is above 0 it will be counted. You can reset on group, or field, or whatever.

10|10000 characters needed characters exceeded
• Former Member
Posted on May 19, 2008 at 09:02 PM

Post Author: rconner

CA Forum: Formula

Thank you, I will try this.

Rick

10|10000 characters needed characters exceeded
• Former Member
Posted on May 19, 2008 at 09:48 PM

Post Author: sharonmtowler

CA Forum: Formula

depends on what version you are using, but the running total wizard has bugs, manual running totals work best, but if you want to just count your records and not sum then try

create a formula

if =0 then 1

then sum the formula.

10|10000 characters needed characters exceeded
• Former Member
Posted on May 20, 2008 at 08:06 PM

Post Author: rconner

CA Forum: Formula

That worked. Thank you very much for the help.

Rick