2 Replies Latest reply: Sep 25, 2018 5:24 AM by Justin Pham RSS

    I need syantax to get Last six months data?

    suresh b

      Pls send me ...

        • Re: I need syantax to get Last six months data?
          Tim Poismans

          I take it you want to limit the load in your script?

          Do you have a date field?

          Do you take the current month as part of the six months, even though it's not complete?

           

           

          Give us a bit more info so we can help you out.

          • Re: I need syantax to get Last six months data?
            Justin Pham

            Hi,

            May try like this:

            // Sum Last six months Sales

             

            sum( 
                      { 
                          < 
                            date=, 
                            Year=, 
                            Month=, 
                            Quarter=, 
                                date={">=$(=AddMonths(Max(date),-6))<=$(=Max(date))"} 
                          > 
                      } 
            Sales) 
            

             

            Hope this helps,

            Justin.