Sum function with 2 Conditions

[london1980]

Hi All,

I've got this sum function that gives me the total of Available_Qty where Country_Code is 7

sum({<[Country_Code]={'$(=7)'}>} [Available_Qty])

I want to add one more condition into this

"and where Warehouse_Code is A1"

Can anyone help me adding this into the function?

thanks

MT

[swuehl · Accepted solution]

You don't need a dollar sign expansion for a constant value.

Try

sum({<[Country_Code]={'7'}, [Warehouse_Code] = {'A1'} >} [Available_Qty])

[london1980]

Works beautifully, many thanks!