Hello,
I have to develope a report that shows 6 Sales Rreps sales totals.
(That is not the part that I am having trouble with.)
What I am finding difficult is coming up with a way to handle the ramp up period for the Guarantee on Commission.
Meaning.... the company pays (for example) a ramp up for the first 5 months that you are employed. The first two months the amount will be the same but but from the 3rd to the 5th month the ramp up amount will be reduced.
Ie,
Month 1 = $1,333
Month 2 = $1,333
Month 3 = $1000
Month 4 = $666
Month 5 = $333
(I have a table that I have entered the ramp up period amounts.)
The problem is this...... each sales rep has a different start date.
Each sales rep gets paid their appropriate commissions they make on their sales plus the ramp up amount.
So how do I on one report show that for example:
Rep Name, Sales, Commission, Ramp up, Total
Peter, $100 $10 $1,333 $1,343
Sue, $200 $20 $666 $686
David, $50 $5 $1,000 $1,005
Does this make it clearer. I am sure there is much more info that I need to supply you with. But if anyone wants to help I can supply that when you need it.
I am certian that the solution will be to have an un bound text box on the report that is attached to an IF Statement. One the looks at the date the Sales Rep is hired and decides something like if month now minus dated hired is egual to 1 or 2... show 1,333.......elseif egual to 3 ....... then show 1000.....etc.
Any help would be appreciated.
I have to develope a report that shows 6 Sales Rreps sales totals.
(That is not the part that I am having trouble with.)
What I am finding difficult is coming up with a way to handle the ramp up period for the Guarantee on Commission.
Meaning.... the company pays (for example) a ramp up for the first 5 months that you are employed. The first two months the amount will be the same but but from the 3rd to the 5th month the ramp up amount will be reduced.
Ie,
Month 1 = $1,333
Month 2 = $1,333
Month 3 = $1000
Month 4 = $666
Month 5 = $333
(I have a table that I have entered the ramp up period amounts.)
The problem is this...... each sales rep has a different start date.
Each sales rep gets paid their appropriate commissions they make on their sales plus the ramp up amount.
So how do I on one report show that for example:
Rep Name, Sales, Commission, Ramp up, Total
Peter, $100 $10 $1,333 $1,343
Sue, $200 $20 $666 $686
David, $50 $5 $1,000 $1,005
Does this make it clearer. I am sure there is much more info that I need to supply you with. But if anyone wants to help I can supply that when you need it.
I am certian that the solution will be to have an un bound text box on the report that is attached to an IF Statement. One the looks at the date the Sales Rep is hired and decides something like if month now minus dated hired is egual to 1 or 2... show 1,333.......elseif egual to 3 ....... then show 1000.....etc.
Any help would be appreciated.
