7 Replies Latest reply: Aug 29, 2017 9:53 AM by lakkyreddy devendar RSS

    Current and Previous Quarter calculations

    Kieron O'Keeffe

      Hi all,

       

      I am creating a Quarter field with the following script:

      'Q' & ceil(right([Acc_Calendar.Acc Period],2)/3) as Quarter   

      How do i then create a vCurrentQuarter and vPreviousQuarter ?

       

      Thanks in advance