I've created a calculated field named 'EE_Hours' in a pivot table and it is incorrectly returning zero for all entries. The underlying data table has a 'Meas' field which are text entries. There is another field named 'Value' which is a number. If 'Meas' = 'Employees' I want to multiply 'Value' by 2,080/12 to get employee hours for the month. If not, I want to return zero. However it ALWAYS returns zero. Even when 'Meas' = 'Employees'. The formula I've entered for the calculated measure is:
=SUM(IF(Meas= "Employees",Value * 2080/12,0))
Any help on why might be this is happening is appreciated.
Thanks
Pivot_Calc.png
Bookmarks