Multi Field Formula

[Meiye]

Hi everyone,

I'm so frustrated by this issue... I use the Multi-Field Formula tool to set selected field to 0s based on the simple function below: 

IF [Total EP]+[Exclude]>0 THEN [_CurrentField_]=0 ELSE [_CurrentField_] ENDIF

but it sets the current fields to -1 where the condition is met (attached). I also tried not using [_CurrentField_] but use the specific columns, also tried using the formula tool for one column at a time, but it stills shows -1?? why?

Appreciate any insight...

Meiye

[ed_hayter · Accepted solution]

Hi @Meiye

Try setting the THEN Result to 0 ELSE [_CurrentField_] in this case the current field value does not need to be specified for the result.

I used:

IF [Exclude] + [Total EP] > 0 then 0 ELSE [_CurrentField_]
ENDIF