4 Replies Latest reply on Oct 18, 2016 5:51 AM by Jason Olson

    Average over Q1, Q1+Q2, Q1+Q2+Q3

    qamar zaman

      Hi,

       

      I have a calculated filed "Average time till payment". Now i want to make a view where i can show Monthly data wil average of (First 3 months, 6 months and 9 months).

      What i need finally is like this. Quarterly average is easy using analysis tab, but i dnot know how to calcualte Avg(6months) and Avg(9months).

       

      Payment TypeJanFebMarAvgQ1AprMayJunAvgQ2Avg(6months)JulAugSepAvgQ3Avg(9months)octnovDecAvgQ4Avg(Year)
      A
      B
      C

       

      Any help?