SUM() function under the Math bucket

[r4upadhye]

I like the cool new features in designer 11.x

However, to my surprise when I searched for a sum() function..... it wasn't there yet

Math bucket has common functions such as Average, Mod, Median and some very complex functions such as Hyperbolic Tangent (an average user don't need it)

But a basic mathematical logic is missing : SUMMATION

Please add SUM() as a function

[SeanAdams]

agree with you on the need @r4upadhye .

@jdunkerley79 has done an incredible job of adding many of the missing functions to Alteryx  (link below).   This may not help you if you're on a locked-down corporate environment like we are, but there's some comfort in knowing that this is solvable and until this is added to the core product you can probably reverse into the capability using the work that James has done.

https://community.alteryx.com/t5/Data-Preparation-Blending/Formula-AddIn-to-make-working-with-Dates-...

(thank you again @jdunkerley79)

[MarqueeCrew]

@r4upadhye & @SeanAdams,

Yes, @jdunkerley79 has created some great add-in functions but SUM isn't one of them.  Recently, SUM was moved from within the math functions to the TOP of the function dropdown list.  It is a basic function that is frequently used.  Alteryx moved it out of the Math group to make it easier to find (alas, not always).

Hopefully this will solve the challenge for you.

Cheers,

Mark

[jdunkerley79]

Sum as a function is part of my add in set. 

Totals ignoring nulls. 

As @MarqueeCrew is present in summarise tool if you data is row based. 

[MarqueeCrew]

I'm standing corrected again 🤓

Sent from my iPhone

[r4upadhye]

Thanks all for your inputs.

I realized that recently sum() was assigned to the summarize tool, but I wish it could be made available in the formula list too.

[snellingjhn]

I agree. I would like to see the sum put back in the Formula tool under Math. Often times I just want to create a new column that is based on a calculation where I just summing an existing field.  I don't see how to make the new field just using the transform summarize tool. I would also like to see functions like Count and CountD in the formula tool as well.

[sbahali]

SUM(A+B) will work if A & B are two columns in a data table and have numeric value

[martinoreb]

I receive an error when trying to using "SUM" in the formula tool. Says SUM is an unknown variable..

[RifferX]

I am blown away that the formula tool is missing SUM. You have got to be kidding me. The Summarize tool is just fine for aggregates, but if I want to simply create another column for say, monthly totals, and keep my line level detail I have to jump through way more hoops to join my datasets.

Absolutely mind blowing.

[KimVDB]

I totally agree.

Could you elaborate on the different hoops needed to add a column with the SUM of another column?

Thank you!