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 |
Solved! Go to Solution.
@lumjingbki Convert the Sales data into double datatype and try using the summarise tool
toNumber([Sales])
@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?