Counting a field /excluding empty values 1

[MrArmstrong]

I have a report that has Sales Orders and with Isuue tickets attached to them. I am now trying to find what percentage of sales orders do not have issue tickets against them.

When I do a count for issue tickets it counts them all even empty values.I only want it to count the actual issue tickets that have sales orders. What formula can i use to say exclude empty fields or count only zeros. I have all empty fields defaulting to zero.

Then I need to Know what percentage all sales orders actually have tickets created.

 

[lbass]

See my response to your other thread.

-LB