How to get the total when a column has negative values

Question

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.

Sales2,929.368.488.488.488.48-18,535.64399.60-4,578.66117.63105,490.042,980.2388,836.48

binu_acs · Accepted Answer

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

toNumber([Sales])

DataNath · Accepted Answer

@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?