2 Replies Latest reply on Jul 29, 2016 12:52 PM by Andrew Watson

    Comparing two values with different dates

    Chris Labriola

      Hello,

       

      We have a somewhat unique data structure and have not found a way around it. Essentially we want to get Net Income (sales - cost) but the trick is that they rely on two different relative date formats. The issue arises since Returned Tickets relies on the processed date field rather than submitted. I'm sure I am missing something since it's a pretty simple thing we want to do.  I've attached a sample workbook with the shape of our data. It includes "tickets" as the example items and the date formats for them would be set to Relative for Yesterday. In the end, we are trying to build a prior day production dashboard with net ticket submissions and processed tickets. Net tickets would be (Submitted Tickets - Returned Tickets) Thank you for any help!