Hi
I want to recreate this formula in Alteryx - iI know it is something to do with summarize tool but not sure how to go about it
Solved! Go to Solution.
Hey @Metadata21,
Could you provide a sample excel sheet? The logic for SUMIFS in Alteryx is just a filter tool followed by a summarize tool using the sum function:
The filter tool is used to select the 'cells' that meet the criteria and the summarise does the SUM.
Any questions or issues please ask :)
HTH!
Ira
@IraWatt please see attached
Hey @Metadata21,
Ah okay what SUMIF is doining here is for each Cd_ BSEnt its suming Sum_Cd_ InvAmt. This is the same as grouping by and summing in Alteryx:
Any questions or issues please ask :)
HTH!
Ira
@IraWatt you are a star! exactly what i wanted! thank you!!!
No worries glad it worked for you ! :)