Add rows for a sum amount

[Massi1]

Hello Alteryx Community, 

I worked 2 weeks with Alteryx and I have question. 

I have a account number as a row. I have a Colum "Amount at the beginning of the period". Then I have 8 Colums behind . Now I need a new Colum. In this Colum a need Sum of the Start Amount and the other 8 Colums, But sometimes 7 Colums are null and one have amount or 3 are null or 6. And if They isn´t Null, they can be a positiv or negativ Amount, so I need the Amount at the end of the period. 

Maybe 

A=12, B=2, C=0 D=-4 and the Sum is 10. 

Can you help me pls? 

Thanks 

[JosephSerpis · Accepted solution]

Hi @Massi1 I mocked up one approach you can take to solve this problem. Let me know what you think?

[wwatson]

I would suggest using the cleanse tool to replace the nulls with 0s.

Then a simple formula will work to total up the columns.