RulesBase is designed to have one formula represent the results of a column of numbers. However, the user may also create an exception to a formula while retaining the audit trail.
Suppose we have rules:
“Data = {3000,4000,2000,1000,4000}”
“Base Formula = Data * 75%”.
The exception in Row 3 might be “Exception = item(3,Data) * 80%”.
Finally, to replace the Base Formula with the Exception use the formula:
“Final Result = item(1 thru 2,Base Formula) | Exception | item(4 thru 5, Base Formula)”