Multi Field Formula

Question

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

2023-06-27_19-09-07.png

ed_hayter · Accepted Answer

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