DISTINCT COUNT 1

[thermalman]

Hi,
I am using CR XI

I am trying to create a formula for the report footer that does a Distinct Count of the WorkOrder.CallNumber but I need it to only count the records where the Status "Followup" =False.
i.e I only want it to count actual closed Calls.

Is a formula the best way to do this?

I know in SQL what I want it to do but I am not sure of how to get Crystal to do it and I need to then pass this figure onto a Summary.

If you need more information please let me know

Regards
Thermalman

 

[AngelB]

Hi there

What you want is a running total.

Right-click the field you want to do the distinct count on and choose insert -> running total.

In the 'type of summary box' choose 'distinct count' and then under the 'evaluate' heading choose the 'Use a formula' radio button.

Click the "X-2" button to open the formula editor and enter your criteria.

Since you want the result to appear in the report footer, you can choose 'never' under the 'reset' options and click OK.

Hope this helps


Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

 

[thermalman]

Hi AngelB,
I have tried to do that and that is why I posted this thread.
I want to do a Distinct count on WorkOrders.CallNo where
Followup =FALSE

here is what I put into the formula Editor
Distinct Count {WorkOrders.GBR_No} where {WorkOrders.FollowUp}=FALSE
but when i try to save it says that the remaining text does not appear to be part of the formula.

please help!

Regards
Thermalman

 

[AngelB]

Hi thermalman,

The formula editor will not recognise your code as you cannot create a distinct count this way.

If you try it with the steps I posted above, the only thing you should need in the formula box is

{WorkOrders.FollowUp} = FALSE

The distinct count running total field will be created for you once you click OK. You can then place it in your report footer.


Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

 

[thermalman]

Hi AngelB, It is easy when you know how.

Many Thanks
Thermalman