Skip to Content
0
Former Member
May 19, 2008 at 04:05 PM

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

14 Views

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