Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You don't need a dollar sign expansion for a constant value.
Try
sum({<[Country_Code]={'7'}, [Warehouse_Code] = {'A1'} >} [Available_Qty])
You don't need a dollar sign expansion for a constant value.
Try
sum({<[Country_Code]={'7'}, [Warehouse_Code] = {'A1'} >} [Available_Qty])
Works beautifully, many thanks!