Hi,

Actually I need to create one excel sheet, which calculates the gap commission in direct selling. I will explain you the process here.

In Marketing, if the downline do sales, the commission has to be calculated for the sponsor person also. Likewise for the entire group.

Say for example if A is the sponsor ID and B,C,D are his direct downlines. Under B there are two more persons and they also doing some sales means A will get the gap commission (B's commission minus A's commission)from group B, C & D. That is if the downlines bonus % is less, then only the sponsor get the gap commission. Like wise from the deeper downlines also the Sponsor get the gap bonus.