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

      Hi,

       

      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.