Hi. I’m just getting used to workflows and reports ( with both table and slice) when I run my report I get every record in the table as opposed to the query expression to just return records where [Completed]=FALSE and [DateAssigned]>TODAY()
COUNT( SELECT( Fleet[Task], AND( [Completed?]=FALSE, [DateAssigned]>TODAY() ) ) ) <> 0
As I look in the table, the data for column [Completed?] containd ‘Y’ or ‘N’ so I changed the expression to:
COUNT( SELECT( Fleet[Task], AND( [Completed?]=“N”, [DateAssigned]>TODAY() ) ) ) <> 0
The report still includes every record.
What am I doing wrong?
Regards
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |