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]
indhu's avatar
indhu
Helper III
8 years ago

 

nmckbcs please find the sample. 

 

Error screen shot:

 

parry2k I tried that as well didn't work getting the same error

 

Thank you both :) 

parry2k's avatar
parry2k
Super User
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

    indhui just tested at my end and it worked see below

     

     

     

    • indhu's avatar
      indhu
      Helper III
      8 years ago

      I figured out what is wrong. I didn't use null case first used that in else if so it didn't work and got error. 

       

      The code I used:

       

      if [Column A] < [Column B] then 0 
else if  [Column A] = null or [Column B] = null then null
else [Column A] - [Column B]

      Thanks parry2k :D works now 

      • 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.