2 Replies Latest reply: Jul 31, 2012 8:59 AM by harry_hhs

# Count(if(  closed 0 and older then 7 days

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!

• ###### Re: Count(if(  closed 0 and older then 7 days

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) `

• ###### Re: Count(if(  closed 0 and older then 7 days

Thank you!

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

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

Works