Calculation not working in Cognos 11.05

[rrutkowski]

I have a field interest rate that is defined as 'unsupported' in the framework because it should not be summed.
The field is used to multiply with ledger balance.  In cognos, when I create this calculation as :
([NOTE_CUR_INT_RTE]*[Note Average Bank Share Balance Mtd])

it comes across in the sql as:
MIN("DIM_C2_NOTE_SCD"."NOTE_CUR_INT_RTE") * SUM("FACT_NOTE_ACCT_M0"."AVG_BNK_SHR_MTD_BAL") AS "Data_Item1

when in fact is should be:
sum("DIM_C2_NOTE_SCD"."NOTE_CUR_INT_RTE" * "FACT_NOTE_ACCT_M0"."AVG_BNK_SHR_MTD_BAL") AS "Data_Item1

HOW DO I FIX THIS?