Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

How to extract a value with a condition from ref table

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 Solved
1 3 321
1 ACCEPTED SOLUTION

SELECT(Work Order[Month], [status]="Closed")

View solution in original post

3 REPLIES 3
Top Labels in this Space