Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
The title pretty much says it all. I'm trying to write an expression that will return the count of events where [YearOccurred] = last year, but I need it to be based on the current date. So right now it would return records where [YearOccurred] = 2014, but on Jan 1 it would return records for 2015.
This isn't working. Does anyone know if I'm close?
=Count( {1<Department={"Repair"}, Year = {"=YearAdd(Year(Today()),-1)"}>} DISTINCT VisitID) |
Thanks in advance!
Try with:
=Count({1<Department={"Repair"},Year={"$(=Year(Today())-1)"}>} DISTINCT VisitID)
it could be ($ or 1 it depends)
count({$ <Department={Repair},Year={$(=Year(Today())-1)}>} distinct VisitID)
Yearadd?
I think it is addyears
Try with:
=Count({1<Department={"Repair"},Year={"$(=Year(Today())-1)"}>} DISTINCT VisitID)
This worked perfectly! Thank you to all who responded so quickly today, and especially Peter for a great answer. Happy Holidays!