How to count the no of sales except last 7 days

[rkpatelqlikview]

Hi,

Can anyone please explain how to count the no of sales except last 7 days from today.

Thanks in advance

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<DateField = {"$(='<=' & Date(Today() - 7))"}>} Transaction_ID)

[rkpatelqlikview]

Thanks Sunny.

Its working.