2 Replies Latest reply: Feb 7, 2016 7:16 AM by Mahm Tamal RSS

    Sum function with 2 Conditions

    Mahm Tamal

      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