Missing values and formulas

[Jack Adams]

Hi! 

I am computing an indicator in a datamanager.

The numerator of the indicator formula is the sum of 3 columns, and it returns missing if at least 1 of the 3 columns is missing.

If the value is missing, I would like to consider it as 0, without modifying the 3 columns. Is it possible?

Thanks

 

[Nicolò]

Hi Jack!

If you write the formula as $”attribute1”+$”attribute2”+…, it returns missing if at least one is missing, but you could use sum(($”attribute1”,$”attribute2”,..)) to obtain your desired result.
Alternatively, you can use ifelse($”attribute1” is None,0,$”attribute1”) + ifelse($”attribute2” is None,0,$”attribute2”)+…..

I hope it helps!

[Jack Adams]

Thank you.

I thought the sum function calculates by column. I'll try it!

 

[Nicolò]

If the argument of a function is a list of multiple attributes enclosed in double brackets, then the sum is performed by row.