if statement with isnull in INDB formula

[Shank]

Hi All,

Can some one help me with INDB formula.

Create a new column with below condition

if Column A is null then take Column B else Column A end

i tried with below formula but it did not work.

if isNull("A")
then "B"
else "A"
end

[fmvizcaino · Accepted solution]

Hi @Shank ,

Which Database are you connecting into?

You can try this two examples:

mySQL: IFNULL([A], [B])

SQL Server: isNULL([A], [B])

https://www.w3schools.com/sql/sql_isnull.asp

Best,

Fernando Vizcaino

[Shank]

@fmvizcaino 

Thanks you so much for your help this is what i was looking for 🙂