Alert Multiple Criteria

[#1]

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

[johnw · Accepted solution]

Maybe this?

min([Open/Closed]='Open' and (today()-[Date reported to / noticed by COPs])>20)

Edit: Added missing (

[#3]

min([Open/Closed]='Open' and (today()-[Date reported to / noticed by COPs])>20)

Thanks John I stuck in a ( and it works perfect

Happy New year
A