[SOLVED] Numbers not added up correctly

David2019

When I'm adding up several numeric fields, the sum is not always calculated correctly. In certain cases the value is shown as [Null] instead of as the actual sum.

To calculate the sum, I use the formula tool:

UnitsVolume_01_2015 + UnitsVolume_02_2015 + ...

Both input and output fields are formatted as double.

When I export the data to Excel and add up the same fields in Excel, sums are calculated correctly. I can't see any misformatted values, leading/trailing white spaces or any other obvious issues that could explain this odd behavior.

Any ideas why the sum could be [Null] instead of the actual value?

Workflow

Accepted answers

jasperlch

Hi @David2019 ,

If any one the components to be summed (i.e. UnitsVolume_01_2015, UnitsVolume_02_2015, ... ) is Null, the result of the summation is Null because in the formula in Alteryx, 1 + 2 + Null = Null but not 3. In order to ask Alteryx to treat Null as zeros, you could use a Data Cleansing tool to replace Null with 0 for all the fields to be used in your formula (before your Formula tool):

All comments

SamDesk

Hi @David2019,

Do you have some sample data you could upload to help diagnose your issue?

Sam

jasperlch

Hi @David2019 ,

David2019

Yes, already solved it in the meantime, but that was exactly the problem, thanks!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235