OBIEE 11g - SQL Conditional COUNT & SUM

To apply condition in COUNT and SUM aggregations, use below methods:

FILTER(COUNT(Column1) USING(Column2 = ‘ABC’))

FILTER(SUM(Column1) USING(Column2 > 0))