2 Replies Latest reply: Jan 3, 2012 4:17 AM by Anne Duffy RSS

    Alert Multiple Criteria

      Hi Guys

       

      I have an Alert on the QV Dashboard that I want based on the following Chart,

      Basically I wish it to fire when field Open/Closed is = 'Open' AND

       

      Diff Between Noticied and Closed  > '20' --- The Calculation for this field is

       

      =if(isnull([Date Closed]),sum(today()-[Date reported to / noticed by COPs]),sum([Date Closed]-[Date reported to / noticed by COPs]))

      I can get it to fire based on the open/close using

      sum

      (if([Open/Closed] ='Open',1))>

      0

       

      but I cant seem to figure it out with the day count also

      Can anyone please help ?

      Thanks

      Compliance.bmp