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 thanks for your reply. 

 

Can I please know how do you replace null with nothing? 

 

In home ribbon replace a value doesn't allow to do it without any values 

 

Thanks,

nmckbcs's avatar
nmckbcs
Helper I
8 years ago

Can you share a sample file?

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    replace you "null" without quotes null

     

    if [ColumnA] = null or [ColumnB] = null the 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]