9 Replies Latest reply: Sep 25, 2015 3:24 PM by Massimo Grossi RSS

    if statement and date functions

    Channing Dionisopoulos

      Hi Community,

       

      I am trying to make a chart like the one below.  I have many fields, two of which are: Open QNs (a columns of 0s and 1s, 0 meaning the QN is not open and 1 meaning that the QN is open, so we care about the 1s) and Createdate (when the QN was created, in number format).  I assigned a variable for each year.  For 2015 for example, this is my expression:

       

      if(today() - CreateDate >60,

      sum(

        {<YEAR_NO={$(vCurrentYear)}>}

      OPEN_QN_FLG), 0)

       

      Basically for each year, I want a sum of all of the open flags (1s) that have been opened for more than 60 days.

       

      Can anyone help me out?

       

      Thanks!

       

      open QNs.png