If I have 2 columns and one of them is null and I use them both in the same formula, for example,
formula = col_1 + col_2, then I get a null result when col_ 2 is null even if col_1 is not null.
When they are both not null, I get a result.
I have tried to test for null as the beginning of the formula: if isnull({col_2) then.... but this does not seem to work. So I have 2 questions:
Am I doing something wrong?
Do I have to test for null in every formula where a field might be null?
formula = col_1 + col_2, then I get a null result when col_ 2 is null even if col_1 is not null.
When they are both not null, I get a result.
I have tried to test for null as the beginning of the formula: if isnull({col_2) then.... but this does not seem to work. So I have 2 questions:
Am I doing something wrong?
Do I have to test for null in every formula where a field might be null?