Hi Everyone,
I currently have a select function in which it returns a list of dates (this function is in a report template ). However, I now need it to be slightly amended so that it will return the date twice in the list if [Session Qty]=2
Does anyone have any idea on how this can be achieved.
<<SORT(SELECT(Case Session[Date], AND([Attendance]=”Attended”, (NOT([Session Name]=”Initial Assessment”)), ([Ref]=[_THISROW].[Case Ref]))))>>
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |