5 Replies Latest reply on Apr 24, 2017 3:34 PM by Venkata Yaswanth Ramisetty

    Max Month By Quarter

    choracy69

      Hi,

       

      I have question about calculate max month on the each quarter form 2016. How can I calcuate this in obiee?

      For example I check 2016 year and I want show on analisys each quarter and their max month:

      Q1 || Month 03

      Q2 || Month 06

      Q3 || Month 09

      Q4 || Month 12

      How create month formule for this?

       

      Or maybe formule for last day for each quarter and then I extract month from date?