1 Reply Latest reply on Feb 12, 2016 8:08 AM by nicolas.allerhand.0

    Cycle of days

    Mattia Pradella

      Hi All,

       

      I'd like to create a field (it can be text) that groups the previous 42 days.

       

      As example:

       

      Given a starting date as the 10/08/14 it gives me a date or text every 42 days.

       

      What I'd like to do is to sum sales in these 42 days.

       

      Can you help?

       

      Thanks.

       

      Mattia

        • 1. Re: Cycle of days
          nicolas.allerhand.0

          Hello Mattia

           

          What you can do is to create a date parameter like this. This will be the day the user choose.

           

          Now, If you want to see the sales for 42 days before the date N parameter, you just create another calculated field like this to get the sales between the both date.

           

          IF DateOfTheSales>DATEADD('day',-42,[Date Now] AND DateOfTheSales<[Date Now]

          THEN [Sales]

          END

           

          Is it what you're looking for ?