Unique Count Except for... (1 Viewer)

[krazykasper]

I am trying to use the Unique Count function to count the records in my report, however for some of the records (those where the field = A) I want to count all of the records. Is there a modification I can make to the Unique Count function?

Sample Records:

Record1 A
Record2 B
Record3 R
Record4 T
Record5 A
Record6 A
Record7 B
Record8 B
Record9 T

My final count should be 6 (3 A's + B + R + T)

All help is truly appreciated.

Krazy (like a fox)

 

[wcelenski]

Count all letters separately, and then create a sum formula summing all of those, or weeding out whatever records you feel you don't want/need.

 

[hully333]

Add a formula and use VB syntax.

If [record] = "a" then formula = 1

place that formula on the details section right click it and choose summary / sum and move that to the header or footer where u want it. Thats a total sum of "A" then. Sum and count will return the same value as its the sum of 1's, Distinct count will return just 1, so use distinct for the other letters for 1 occurance of them. Then add another formula that adds the summaries together (the distinctcounts and the sum of A's)