September 6, 200124 yr I need to calculate an initial commission fee, then a monthly residual fee for 2 years (as long as the referred account stays open for the 2 years). Can anyone give me a clue as to how to begin? Much appreciated....
September 7, 200124 yr Probably not without more information. What is your file structure? What are the formulas for your initial commission fee and monthly residual fee? -bd
September 7, 200124 yr Author What I'm trying to design is a set of records to keep track of commissions for an affiliate program. One idea we had was to give each referred account a unique number, then calculate the commission on their individual record and post the result on the affiliate's record (probably in a related database). We will pay out the commission when the affiliate's account reaches $50 or more. Then funds will begin to accumulate again. I will post again when I have thought this through a bit more. All ideas welcome and greatly appreciated.
Create an account or sign in to comment