Forum Discussion
_anomDiebolt_
7 years agoQrew Elite
No matter how many tables you use to store your information or how they are related to perform the Multilevel Marketing Commission calculation you are going to have to use either (1) a static hierarchy of known levels with fixed commission rules implemented through native lookup / summary fields or (2) script to dynamically calculate and store the commissions at each level. This will be true even if you follow Mark's suggestion of relating a table to itself.
Furthermore, you don't describe the commission equations or overrides. I would suggest your look at some of the online MLM commission calculators and relate the one that applies to your commission structure to your existing table structure.
Furthermore, you don't describe the commission equations or overrides. I would suggest your look at some of the online MLM commission calculators and relate the one that applies to your commission structure to your existing table structure.