Count(if( closed 0 and older then 7 days

[#1]

Hello,

Probaly it's a small thing what i'm doing wrong, tried many combinations but aint getting te result i want.

if ( IN_closed='0', Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"} >} IN_number))

Works, but i have to manualy select the IN_closed 0. (by selecting it in list box for example)

count (if(IN_closed='0' , IN_number) )

Works, but it shows all with condition IN_closed 0, i want only results shown wich are 7 days older.

Can someone help me with this?

Thanks in advance!

[swuehl · Accepted solution]

Try

Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"} >}

if ( IN_closed='0', IN_number))

or

Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"}, IN_closed = {0} >} IN_number)

[#3]

Thank you!

Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"} >}

if ( IN_closed='0', IN_number))

Works