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]
parry2k's avatar
parry2k
Super User
8 years ago

indhualthough it worked after you moved the first if condition but I'm still not sure why it didn't work when it was first condition, still curious to find out the underline issue.

indhu's avatar
indhu
Helper III
8 years ago

weird but felt the same. Will dig it if I can and post here :)