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.
