Having trouble multiplying a measure by a dimension

[aheavy95]

Hi all 

In my app,  I am trying to multiply a quantity measure with set analysis (3rd column) by a price field to get the total costs, but  I get null:

The measure works only when The product ( suri_wrin) is filtered to the product that is in the set analysis

The second row is the product that is included in the set analysis of the measure 

The total cost measure:

Sum({<SURI_WRIN_S = {'10045210','19045001'},Transaction_Type_S={'SL_C'}>}TotalQty_Tran_S)* PRICE 

Any idea what is the cause for this?

[Or]

Rule of thumb: Your measure should include all of the values you plan to use within the aggregation scope. There is no such thing as "Multiplying by a dimension".

Sum({<SURI_WRIN_S = {'10045210','19045001'},Transaction_Type_S={'SL_C'}>}TotalQty_Tran_S)* PRICE 

is the same as:

Sum({<SURI_WRIN_S = {'10045210','19045001'},Transaction_Type_S={'SL_C'}>}TotalQty_Tran_S)* Only(PRICE)

It seems like you should be using Sum(Amount*Price) instead?