Forum Discussion

indhu's avatar
indhu
Helper III
8 years ago
Solved

Handle null values in custom column

I have two columns which have null values I want to create a new custom column which finds the difference between them producing null values as such.    I am aware that I can convert the null value...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    sorry there was typo in my formula, it suppose to be then instead of the

     

    if [ColumnA] = null or [ColumnB] = null then null
else if  [ColumnA] < [ColumnB] then 0 
else [ColumnA] - [ColumnB]
AAwad's avatar
AAwad
New Member
3 years ago

Try the Replacer function:

Replacer.ReplaceValue(value as any, old as any, new as any)

For Example:

Replacer.ReplaceValue([ColumnA],null,0)

 will return 0, so you can use it in your custom column for all the columns that you will use to handle nulls in these columns.

So using this function for any column in your formula will always return a value instead of returning an error.