Help with setting up a calculation field
I am trying to set up a calculation for a commision. The commision percentage changes based on the gross sales for the year. I finally worked out the calulation using summary fields, but I am not sure how to reset it for the next year. I can't use the date as a break field since I am already breaking it by salesman.
Is there an easy way to do this? Or should I just have separate databases for 2008, 2009, etc?