Creating Null Values in Number Fields

[sbaker]

I would like to make line graphs dead-end by changing 0 to Nulls in Double fields. The following function returned -1, instead of Null (the function does correctly return 0 when I replace Null with 0). Is it possible to convert to Nulls or Blanks in Number fields?

IF [JTD_RemainingUnits]>0
THEN [_CurrentField_] 
ELSE [_CurrentField_] = Null()
ENDIF

[JohnJPS · Accepted solution]

Hi @sbaker

I believe it's returning the truth value of [_CurrentFIeld_] = Null(), which is -1.

Try the following:

IF [JTD_RemainingUnits]>0
THEN [_CurrentField_] 
ELSE Null()
ENDIF