Count Formula 3

[dday01]

Hi all,

I am a total CR novice. I need the syntax for a formula that will give a distinct count of field1 if field2 is equal to a certain value. Any help would be greatly appreciated.

Thanks,

D

 

[mbarron]

The best (and easiest) way to do this is with the built in running total feature.

To use the RT feature, go to insert/ field object. Create a new running total. Pick the field you want to count, then for your "Evaluate" choose a formula and click the (x-2) button. Enter the formula you want to use to evaluate field 2. Eg {field2} = "OVERDUE"

The other way would be by using a manual running total that would contain a "growing" array.

Mike

 

[synapsevampire]

Use a Running Total (Insert->Field Object->Right Click Running Totals and Select New).

Place Field1 in the Field to Summarize

Select Distinct Count for the type of Summary

Select Evaluate->use a formula->X 2

Place something like:

{table.field2} > 100

-k

 

[dday01]

Thank you both for your responses. This gets me closer. The right numbers are coming up but the running totals is a problem. I have a grouping in my report and I need the distinct count to be for each group, where as the running total keeps adding on for each group. I know I should have mentioned that originally. Do you have any ideas of how to get around this? Any help is greatly appreciated.

Thanks,

D

 

[crystalfma]

dday01,

You can reset the count on change of group. Its the section after Evaluate in your running totals formual.

-f

 

[dday01]

Hey! That did it! Much appreciation to all that helped! This friday is getting better by the minute.

D