Sum If

[codyfink]

So I am used to using Excel and Sum Ifs. Is there anyway to do that in Alteryx. Basically I have multiple part numbers in the Part column that are same I am trying to combine and sum the PO quanity. For example line 3 and 4 are the same part I only want one column with the PO quanitty being the sum of both which would be 513pcs?

[MilindG]

@codyfink You can use the Summarize tool and group by the string field and sum the Int field

[caltang]

Yeah, use the Summarize tool to Group by those dimensions and Sum the measures you want provided the data types are correct. Dimensions should ideally be V_WStrings and measures should be numeric in nature.

Best,

Cal

[caltang]

@codyfink 

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/