I have a parent table with jobs (name, address, etc.). I have a child record associated with each of those parent records depending on the job. There may be one child record for chainsaw work in the chainsaw table, one for demolition work in the demo table, etc. I want to create a slice to show the jobs records where the "Skidsteer" field (needs heavy equipment to move debris) is "true" in either the chainsaw child table or the demo child table. That will show me who needs heavy equipment. I need several fields in the parent jobs records to show as well, thus the need for the slice from that table.
What expression(s) do I need to accomplish this? When I try this formula:
[Related Trees][Skidsteer]=TRUE
I get: "Cannot compare list with Yes/No in this formula"
Note that [Skidsteer} is a TRUE/FALSE field in the child table "Trees"
Thanks for your help!
Solved! Go to Solution.
IN(TRUE, [Related Trees][Skidsteer])
IN(TRUE, [Related Trees][Skidsteer])
Perfect! Thanks for the help...
User | Count |
---|---|
18 | |
11 | |
7 | |
5 | |
5 |