SUM OF TWO COLUMNS

[samxhander09]

Hi Community

Im attaching a workflow I'm currently working on and I cannot figure out how to make my output exactly like the expected. Some of the data match, some don't. Appreciate if you can help me figure this out.

[alexnajm]

It's hard to see a consistent way you want to add these columns together - the Alteryx workflow is acting exactly as I'd expect it to based on the signs. Based on the expected output, it looks like you want to MINUS on records 2, 3, 4, and 6 but add on the others

In addition, records 13 and 16 in your expected output don't do any data addition/subtraction...

[caltang]

I agree with @alexnajm - your logic doesn't seem consistent. But in any case, I've done something for you based on what I assume to be your proper logic. 

Basically, those with () means negative values, and they will subtract from additional demand thereby leading to a greater negative value in additional inventory. 

Whereas those without () means positive values, and they will add from additional demand thereby leading to a greater positive value in additional inventory. 

Kindly confirm if this is the case @samxhander09 - if not, kindly provide as much detail as possible.