"Count" formula giving me a fit!

You guys solved my problem last time so I'm counting on you again! :D

I want to count the number of times the word "CAN" appears on my report. So I wrote a formula that is simply this:

Count (["CAN"])

However, it continually returns the value "1" no matter how many times the word is shown on the report. Like it's a boolean or something.

Don't know if this matters, but the field it is counting up is also a formula. Here is that forumla: If {fieldname}=<-0 then "CAN"

I've tried everything, can you please help??Count (["CAN"]) won't work because it will count the number of array elements, but "CAN" is the only element.

Try creating a new formula
if {fieldname}=<0 then 1

and then creating subtotal for this formula with SUM operation.|||That worked great!! Except my formula couldn't have the = sign directly after the field name.

So my formula is:

if {fieldname}<=0 then 1

Thank you greatly!