I am trying to sum, using an LOD. I want to exclude values from the calculation when another field has a specific value... when i try to add an if statement, i get numbers much higher than expected. when i don't add the if statement, i get the expected

{ FIXED [Geography]: 

SUM(

IF ( [NAICS Code] <> "000000")

THEN

[Base Ind Employment]

ELSE

0

END

)

}

notice the change in Base Employment Total by Area go up when i add the IF statement