Hello Everyone,
I'm very new to Alteryx. So I just want a simple calculation to sum of rows across in column "Total Pmt - Expected Result" as attached below.
Thank you so much
Hi @whitesummer05
Here it is using the standard tools
Aidan
Try this out , will do the calculation if any new columns are added which needs to be part of the sum . I have left the Sum_Value column next to the Total-PMT Expected result column for you to comapre
Hello @whitesummer05
Welcome to Alteryx! The easiest way to do this is to get the CreW Macro pack from http://www.chaosreignswithin.com/p/macros.html. This will add some new tools to your alteryx and one of these is Add Totals tool which does this really well. The macro pack has a lot of really good and very useful tools.
thanks
chris
OMG. It's my first time posting something on this forum. I have never expected so much help from this community. I sincerely appreciate everyone's help. I'll definitely post more problem from now on. I've been struggle with this for hours. Didn't know I just need to replace null with zero to do the calculation. Thank you so much
Thanks for sharing this Macro, really helpful.
How we do sum of row..
