Replacing a null or 0 value with 1 in an column

Question

Hi Team,

I need help.

i have a column with null and 0 and i need to replace both of them with 1.

can you please help?

thanks

Sri

Col1NULLNULL003

Emil_Kos · Accepted Answer

Hi,

The IF function that you need to use is

IIF(isnull([Col1]) OR [Col1]=0,1,[Col1])

OR alterynativly diffrent syntax

IF isnull([Col1]) OR [Col1]=0 THEN 1 ELSE [Col1] ENDIF

AlexandreBall · Accepted Answer

Hey Sri,

You can apply a conditional formula with the formula tool.

For instance:

IF [Col1] = Null()
OR [Col1] = 0
THEN 1
ELSE [Col1]
ENDIF

Kind regards,

Alexandre