How to get the total when a column has negative values

[lumjingbki]

Hi in excel when i sum up the below values I get 88,836.48 ie the negative values are subtracted automatically while calculating the sum. How can I achieve this is alteryx workflow I used the summarize tool and took the sum but it is giving me all added values.

Sales
2,929.36
8.48
8.48
8.48
8.48
-18,535.64
399.60
-4,578.66
117.63
105,490.04
2,980.23
88,836.48

[binuacs · Accepted solution]

@lumjingbki Convert the Sales data into double datatype and try using the summarise tool

toNumber([Sales])

[DataNath · Accepted solution]

@lumjingbki are you able to show your current setup/configuration? Just tried this myself and it works fine i.e. outputs 88836.48. The only thing I suspect is how you're converting to numeric (as the current field will be strings due to the comma separators) - you may be losing the '-' symbols somewhere?