4 Replies Latest reply on Oct 12, 2018 2:49 AM by Alex Martino

    How to subtract dates to first date with data

    Alex Martino

      I have a number of products with sales data over a 30 day period. I want to find the number of days in that period FROM the date where the data was above 0. So if September 9th was the first date of >0 for a product, I want to return the difference between that and the end date. How can I do this?

       

       

      See tab "last 30 days"