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