Sum multiple columns and ignore nulls

[CostinelRO]

I want to sum multiple columns and ignore the null values.

I added the columns in a table and it looks like this. To be achieved is what I want to obtain

Name	Sale1	Sale2	Sale3	To be achieved
A	5	3	2	10
B	7	-	4	11
C	-	5	1	6
D	5	-	-	5

I tried to apply sum ( {<Plain ={"*"}>}Sale1) but this does gives different results.

Is there a way to sum like Sale1 + Sale2 + Sale3 and ignore the nulls?

Or maybe it's better to do this from the load?

Thanks in advance

[Fernando_Fabregas · Accepted solution]

Hi ! You can use: 

Alt(Sale1,0) + Alt(Sale2,0) + Alt(Sale3,0)

Regards, Fernando