Sum two filters or more

[Anonymous]

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

[jwjackso · Accepted solution]

Try Sum({$<[product type]={'FIX','TIME_WINDOW'}>} [Count Shipment])