1 Reply Latest reply: Feb 13, 2018 7:17 AM by Jerry Jackson RSS

    Sum two filters or more

    Sachin Nataraj

      Hello,

       

      In KPI I am trying to sum two or more filters which are in same column.

       

      Sum({$<[ product type]={"FIX"}>} and {$<[ product type]={"FIX"}>}[Count Shipment]) [this gives an error]


      Sum({$<[product type]={"FIX"},[product type]={"TIME_WINDOW"}>}[Count Shipment]) [this only reads the last one (TIME_WINDOW)]


      Can you please help me with this.


      Thank you & Regards,


      Sachin