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


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



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

      Can anyone please help ?