Dear Community,
I have a form where I need to display the values of various Descriptions of Work based on the Nature of Work selected which is an Enum List value.
I usually use a Select command for the selection based on the Single Nature of Work value. But, I am stuck with the multiple Nature of Work values & the corresponding Descriptions.
Any help would be greatly appreciated.
Thank you.
Solved! Go to Solution.
You could write it like SELECT(TableName[Description],IN([Nature of Work],[_THISROW].[Nature of Work]))
User | Count |
---|---|
33 | |
11 | |
3 | |
2 | |
2 |