I have done an application to generate a report. There should be select month and select document button.
These buttons is from referenced table. I would like to only able the select month value for the status closed. I tried (Work Order[status] = “Closed”, Work Order[Month]) but unfortunately it returns error and say list cannot be compared with text.
Work Order = tablename
Does anyone have any other suggestion for me to fix this issue ?
Solved! Go to Solution.
SELECT(Work Order[Month], [status]="Closed")
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |