6 Replies Latest reply on Nov 3, 2015 4:07 AM by Chris McClellan

    Calculate Period since last order in the current month

    Amos Mbugua



      I need to calculate the no of days since a customer last ordered from us.


      I have the following calculated fields:


      1st Order Date-{Fixed Customername : MIN(order  date)}

      Last Order Date-{ Fixed Customername : MAX(order  date)}


      But I want to know how long it has been since a customer last ordered in a certain month e.g. in September 2015 how many customers had not ordered for 30 days and so forth.