Best Of

That's bizarre. The "fix" looks a more like a magical spell than a logical cure, but maybe it will help troubleshooting. Thanks!

lol….Yeah, who's Brent?

I don't see anything where you designate the % split across time. One way you could do this is to organize something to show the date duration and split %, maybe something like:

You could add more splits or rule without changing code.

I'm not seeing Brent in your sample table so I'm having trouble visualizing a solution, but maybe that is part of your issue because that is how the data is coming across?
Regardless, I often use a webform or similar to create a lookup table to help with the effective date piece. I may have some other ideas based on what your sample table actually looks like.

Careful though—if you run it three times in a row while holding down Shift, you might accidentally summon a demon.