This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to sum across a few columns then subtract that value from the sum of another group of collumns. For example- I want to sum the total of all fruit, sum all vegetables then get the difference. How would I do this in alteryx?
If it's just thoe few columns, I would do it directly like this: Drag a Formula tool onto the canvas connected to your data. Pick some numeric data type (ex. int32) and give it a meaningful name, for example 'FruitLessVeggies'. Your fomrula would be:
I might have found a solution! But would like some validation. I used the multi Row formula to sum. The data is looking correct.. But to complete the action I wanted I had to use it three times.. Is there a faster way?
Thank you! In truth its more complicated than that, but that is the general idea. I think some of my values downstream had an incorrect (non numeric) data type.. I have been banging my head for why the formula wasnt working. But im guessing if I fix that it will be good.