Calculated Field showing ZERO rather than correct value

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

Thanks for your reply rorya. I certainly can use the 'IF' statement since I can find several examples of this on Excel tutorial pages. I tried taking the SUM off and just going with this:

=IF(Meas= "Employees",Value * 2080/12,0)

Thinking that perhaps the SUM aggregation is actually not necessary. But I still get zeros...

Why would this not work? Thanks.

Thanks for the explanation rorya. I'll have to go back to the drawing board on technique here then.

Just a thought and maybe I'm way off base, but is it possible that instead of Value the formula should say Sum of Value in order to match the column header?