Variance from total

@will.marriott & @jmills

Hang on a mo, I may be barking up the wrong tree, please ignore if I am not understanding your inital requirement. Wouldn’t this get you what you need?
It may be nasty custom code but think its dooable.

Regards,

Jon