Find Target Sum Column Combinations

Options

Allow Closest Not Exceeding: Specify whether if no exact match, or match within tolerance is found, whether you will accept the combination of columns with the closest match that does not exceed the target value
Key Column: Choose the column that is the identifying unique key for each row
Target Value Column: Choose the column that specifies the target value to find for each row
Tolerance to Target Calculation: Specify the maximum tolerance (difference) between the sum of the columns and the target value that will be considered a match
Round Error Decimal Places: Specify the number of decimal places to round to to avoid rounding errors within python
Value Column Name prefix: Specify the prefix for the value column names. Value columns should all have the same prefix followed by an integer%%00010e.g. %%00010Value1, Value2