Counting String Values in Multiple Dimensions from SQL Data Source

Hello,

I am pulling data directly from a sql database with multiple dimensions.  I'm attempting to count common values from each dimension.  In the example below I would like to count the number of common values (ie A-) in each course by Program.  The result that I want would be for Program 1 and value A- a count of 3 or for Program 2 and value C+ a result of 2.  The result that I get is a count of 1.  I created the calculated field:

IF[ADED105] ="A-"

OR [COMM101] ="A-"

OR[COMM178]="A-"

OR[COMM184]="A-"

OR[SPCH101]="A-"

THEN 1

ELSE 0

END

I have tried formulas for CONTAINS, COUNT, with the same result as the formula above.  Does anyone have any recommendations?