Suppress Zeros

[rchiew604]

Hi,

Below is a measure in my dashboard:

Sum(total [Position FTE]*(HCPAPC/1000000000))* (Sum({<[Object Account]={">=50011<=50019"} >}[Position FTE]*HCPAPC/1000000000)
/Sum({<[Object Account]={">=50011<=50019"} >} total [Position FTE]*(HCPAPC/1000000000)))-
Sum({<Employee_Status={'0'},[Emp HBU] ={"<650",">673"} >} Employee_FTE/100)

It outputs positive numbers, zero and negative numbers. However, we only want to remove all the zeros and only the positive / negative numbers.

How do I modify the expression to suppress zero?

Thanks.

[rchiew604]

Unchecked the 'include zero values' under Data handling but zeros still show.