Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone please explain how to count the no of sales except last 7 days from today.
Thanks in advance
May be this
Count(DISTINCT {<DateField = {"$(='<=' & Date(Today() - 7))"}>} Transaction_ID)
May be this
Count(DISTINCT {<DateField = {"$(='<=' & Date(Today() - 7))"}>} Transaction_ID)
Thanks Sunny.
Its working.