Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to calculatte Count(distinct [Attendance ID]) where WeekStart(Today() = WeekStart(Linkdate)
Give me a clue please?
Andy
Sorry still no joy
A sample to look at?
Sorry no can do!
okay
Hi Andy maybe is easier as:
Count(DISTINCT {<Linkdate = {">=WeekStart(Today())<=WeekEnd(Today())"}>} [Attendance ID])
To be in the same weekstart both dates have to be in the same today-week
Ruben - Did you miss the dollar sign expansions?
Sure, thanks:
Count(DISTINCT {<Linkdate = {">=$(=Date(WeekStart(Today())))<=$(=Date(WeekEnd(Today())))"}>} [Attendance ID])
Also date formats can be an issue here...Maybe I'm repeating something, I didn't read all the posts carefully.
I tried to propose these options (at least similar)... but nothing worked... but awhitfield is not willing or able to share a sample... makes it difficult to say much...