Forum Discussion
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...
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]
Hello,
I have a similar situation where I am looking at two columns and creating a custom column based on the two columns.
However, I am not getting the expected result. What am I doing wrong?
Anonymous you first condition should be like below
if [Active] = true
Thank you :smileyhappy:
One of these days I'll remember to lower case TRUE in M. Thank you parry2k!
