โ<<Start: Select(Due in Today[JobID], TRUE)>><<[JobID]>><<Eโฆnd>>โ
Hi
The above will return Individual JobIDโs in each row, which is fine. Bit can I count those rows instead? How would I tweak the above expression to just give me the count of rows?
Thanks
Solved! Go to Solution.
Just put <<COUNT(Select(Due in Today[JobID], TRUE))>> in the template document
<<START: โฆ is only really when you want pull in a set of rows of data such as into a table
COUNT(Select(Due in Today[JobID], TRUE)) ?
Hi Simon, much appreciated. The report fails on:
โErrorsโ: โError: Report โSummaryโ action โSend Summaryโ Attachment template. Start expression โCOUNT(Select(Completed This Month [JobID], TRUE))โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table.โ,
โEmailToโ: โโฆhiddenโฆโ,
Any ideas why?
[JobID] is a key column.
Select(Due in Today[JobID], TRUE) will return a list of Ref column IDs
COUNT(Select(Due in Today[JobID], TRUE)) will always just be a number
A start conditon MUST return a of Refs
I think I understand that. I only want to count [JobID]'s and not return a list.
Iโve tried:
โ<<Start: COUNT(Select(Due in Today[JobID], TRUE))>><<[JobID]>><<Eโฆnd>>โ
โ<<Start: COUNT(Select(Due in Today[JobID], TRUE))>><<Eโฆnd>>โ
โ<<Start: COUNT(Select(Due in Today[JobID]))>><<[JobID]>><<Eโฆnd>>โ
And a couple of other variations, I donโt know how to fix this.
Just put <<COUNT(Select(Due in Today[JobID], TRUE))>> in the template document
<<START: โฆ is only really when you want pull in a set of rows of data such as into a table
Aaaahโฆ Got it and it works.
Thanks you again Simon.
Kind Regards
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |