I have an objectype in insight with a select list where multiple things can be selected. It’s used a sort of progress evaluation: The more selects are on the object the worse it’s doing.
I want to make a report that tells me per object how many selects from the list are on that object.
Here is the table, currenly showing which selects are applicable
Can anyone help?
I tried using Count on currentmember, but it gives result 2 for all my objects, which is not correct.
In the future I will also have to exclude counting 1 value on the select list. Can someone help me with this also? Thank you