=Count 0 values

[vidguru]

Hi. I am doing a report, and I am using the following formula:

=Count(IIf([Not Found]="A1",""))

Untilmately, the report is grouped:
Region
Activity code

I have the about code next to activity code because there are sub
codes to each activity code. I do NOT want these going down, I want
it to look like:

Region xxxx a1 a2 a3
100 - Test 5 7

I have the above formula in the column for a1 a2 a3. I have this code
in the Activity Header so that for each activity code it is doing
this.

It works great. HOWEVER, for the above example, a2, it WILL display 0
for the value. That value is correct, but I would rater it be blank
than show a 0. How do I do that?

 

[Marshall Barton]

Hi. I am doing a report, and I am using the following formula:

=Count(IIf([Not Found]="A1",""))

Untilmately, the report is grouped:
Region
Activity code

I have the about code next to activity code because there are sub
codes to each activity code. I do NOT want these going down, I want
it to look like:

Region xxxx a1 a2 a3
100 - Test 5 7

I have the above formula in the column for a1 a2 a3. I have this code
in the Activity Header so that for each activity code it is doing
this.

It works great. HOWEVER, for the above example, a2, it WILL display 0
for the value. That value is correct, but I would rater it be blank
than show a 0. How do I do that?

Set the text box's Format propeprty to a custom format like:
0;-0;""