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
6 years ago

Anonymous you first condition should be like below

 

if [Active] = true
PhilDanley's avatar
PhilDanley
Advocate I
3 years ago

One of these days I'll remember to lower case TRUE in M. Thank you parry2k!