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

    Count of data in a particular quarter



      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!