I've been trying to find this answer to this question, but with no sucess so far.
I have a List Box with several values, and a value that should always be excluded. This is the rule unless I need to generate a table/chart/text box with that information.
In short, it HAS to be there, but always excluded/filtered from same listbox.
However, when the user selects something in that listbox and than disselects, all values in that field are included. I don't want to condition all charts with set analysis, I think it would be easier to make a default state in a List Box.
Meaning if nothing is selected in the listbox, exclude that value.
So I want to use an expression in a List Box. Currently I have
=if(GetSelectedCount(GroupCd) > 1,
GroupCd, GroupCd =-'CONSUMPTION')
Clearly, I have my syntax wrong, and can't, for the life of me, get it to work.