Finding the first occurrence
Hi everyone - does anyone have any recommendations on how to accomplish this?
We have an ongoing contest for our sales people like this:
1)First sale of the week receives 100 dollar commission
2) Second sale of the week receives 50 dollar commision
and so on...
I am trying to find a calculation to find the 1st, 2nd, 3rd, etc occurrence of the sales for the week specified in the layout between startdate/stopdate. The sales agent field is sales_agent and the sale field is a number field named sales_price, along with the date/time field
I might be going at this the wrong way, perhaps it would be best when they data entry person inputs the sale to run a calculation there first to see if they are the first, second, whatever...anyways, any input would be appreciated thanks!