1 Reply Latest reply on Apr 4, 2018 10:41 AM by Deepak Rai

    Returning a Null with a Value

    Adam King

      Hi,

       

      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?

       

      Thanks!