Forum Discussion
Solved
Calculate column handling Null values
Need to add 2 columns together, however one of the columns may contain a Null value and if Null the return the original value. what is the proper syntax? I need to add the Revenue columns and al...
select the column => Transform tab => Replace Values => Value To Find: null Replace With: 0
You may have do this step "Replaced Value" before the "Added Custom" where you add the 2 columns
try this (case sensitive)
=if [column 1] = null then [column 2] else [column 1] + [column 2]