1 Reply Latest reply: Apr 18, 2012 10:47 AM by Iyyappan v RSS

    Count of data in a particular quarter

      Hi,

       

      I need to calculate the count of glucose values with dates in the Q1, then Q2,Q3,Q4.

       

      The columns in the table to be used are:

       

      Glucose     Date

       

      I think I might need something like.

       

      count(if([Date]>=Jan and [Date]<=April,Glucose))

       

      Please advise!

       

       

      Thanks in Advance!