I am working on quota attainment for our sales staff. I am using 2 different data sources. The one data source is shows sold revenue and the other data source shows quota. So when I use the sold revenue data source as the date, I have NULL values because there are some months salespeople do not sell anything but they do still have a quota.
I am thinking I should incorporate the salesperson's start and end date, and in between those dates, I would want to return their quota. Is there an equation for that?