Subtracting total of duplicate rows from a different field

johneodell

I'm working on converting some Excel data to Alteryx and have been having trouble with one of the formulas. I have two columns of values and the excel file is is using a sumif to compare the TOTAL of values in Value 2 to the value listed in Value 1 for two possible actions:

New Value Action #1: if value 1<value 2 then use value 1

New Value Action #2: if value 1<the total of multiple value 2 keys, the subtract total value 2 from value 1

I know my explanation is a bit confusing so let me know if you have any clarifying questions. Any help is greatly appreciated.

echuong1

Do you want the two "actions" to create separate columns or should both sets of rules be consolidated for a single new column. 

If I understand your criteria correctly, the attached workflow should work for your purposes. I demonstrated both separate new columns and a consolidated one. Essentially, you want to find the total of column 2 and then add these values to each record for the comparison. 

Let me know if that helps or if you need further adjustments/clarification. 

New Workflow14.yxmd