We did something "similar" that might work in this case too.
New Entity - lets call it "revenue split" - with relationship to opportunity
This entity would have a field to assign a user (user reference), possibility to add percentage (0-100) number field, and a value number field again
Then you would leverage workflows (part of Advanced pack), and you would define rules to calculate the revenue or possibly BPM process? because it might be a bit more complex.
There you would cover scenarios like:
New revenue split added to opportunity > update revenue split's resulting value (percentage of the opportunity value)
or New opportunity added > add revenue split with 100% and user assigned to revenue split is the one who is owner of the opportunity
etc...
Sure, it will require to update the revenue splits then manually to make them match 100%, e.g. you add third revenue split of 20% whilst the other two were 50%, you would need to recalculate the others - but chances are you would be able to use workflows for this calculation too quite easily actually.
And then you would generate reports based on the revenue splits, user and opportunities won.
I might be missing something

Leave a comment: