J.B.
I think the simplest way to do this would be to add a checkbox to the individual programs and leave it up to the affiliates
Checkbox: This program does NOT carry over negative revenue – exclude Negative earnings from calculations (i.e., Negative Money = $0)
There is no easy way for you to make a ruleset for each program especially since Terms and Conditions (along with revenue percentages) do change on occassion.
If you leave this up to us, then we can easily select the checkbox and then the math will be correct.