Hi Everyone, I've been able to figure out how to sum the columns by variable, but it's accommodating a the limit and jumping past certain entries that is confounding me. Premise is we have a certain budget for each zip code in America and we have offers from each zip code ranked by internal ranking. I want to be able to skip an offer if it brings us over the limit to jump to a lower offer. For Example with current programming: Zip Offer Zip Code Limit Cumulative Sum Status 10002 $650 $1,000 $650 Accept 10002 $200 $1,000 $850 Accept 10002 $400 $1,000 $1250 Reject 10002 $100 $1,000 $1350 Reject 10002 $50 $1,000 $1400 Reject Using the existing Retain command to get the cumulative offers, the last three offers would automatically be rejected. However, what I want to happen is for the program to skip the third offer and count and accept the last two offers that meet the standards.
... View more