AnsweredAssumed Answered

Finding the first occurrence

Question asked by TGreen on May 7, 2015
Latest reply on May 8, 2015 by TGreen


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!