Count number of two columns 3

[Rainer2000]

I have a report which gives me an overview how many succesful quotes I made.
One column shows the total quotes which I can sum perfectly using =count([requests]).
But all effords so far failed to count the other column showing the orders. I would need something like
Count all records >0, meaning there is a valid order number.
e.g a conditional count.
Help woud be appreciated

Rainer

 

[THWatson]

Rainer
Here's one approach...

1. Create a text box in the Detail section that gives a value of 1 to a request that is greater than 0, and a 0 if the request is 0. Something like
=IIf([TheRequestField]>0,1,0)
Make it a Running Sum over-all
Make it invisible

2. Reference that text box in your Report Footer.

Tom

 

[Rainer2000]

Hi Tom,

Thank you for your "simple" and efficient solution. It works perfect.

Rainer

 

[Remou]

Hi
Here is another possibility:
=Sum(Abs([OrderNo]>0))

This will count Order Nos.

 

[Rainer2000]

Hi Remou,

Yes, another intertesting approach quite similar what I was trying. I think I did not use "Abs".

Rainer