Count of a COUNT field

[DBAFrog]

I have a crosstab report of approx. 3500 records. the total col is 1 to 5. SO,I have about 2500 1's, 1000 2's 350 3's ... etc, but I can't figure out how to get the EXACT count of the TOTAL col.
My field in there is {Count of REFERRAL.CASE}, but I set up a Formula field like
NumberVar x :=0;
if {Count of REFERRAL.CASE} = 2 then
x = x + 1;

But, this returns '{Count of REFERRAL.CASE}' is not a known field.

mmm... How do I get a count for this total field??? I am prepared to create 7 formula fields, one for each number 1 thru 7, unless there is an easier way.

Thanks,

Frog

------------------
Curious by Nature,
Linux by Design

 

[lbass]

Is this an inserted crosstab or a manual one? Please explain what your row field, column field, and summary fields are. Are you now trying to summarize the total column for the row field by counting how many rows have the result = 1 (or 2, 3, 4, 5). Some sample data would help, along with a sample display of how you would like your results to look.

-LB

 

[DBAFrog]

I used the crosstab wizard to create the new file.

and the col are | TOTAL |
the rows are | ID.ID# | {count of REFERRAL.CASE}|


Again, I am trying to create a formula to COUNT the number of {count of REFFERAL.CASE} in the TOTAL column

Are you now trying to summarize the total column for the row field by counting how many rows have the result = 1 (or 2, 3, 4, 5).

EXACTLY


TIA for your help.



------------------
Curious by Nature,
Linux by Design

 

[DBAFrog]

RESOLUTION...

I exported the crosstab report to EXCEL and created a simple =Countif formula for the Total Col.

I had my answer(s) in about 30 seconds.


thanks for your help tho'

Frog

------------------
Curious by Nature,
Linux by Design