"Always One Selected Value" option is disabled when using expression
I have a dimension Account that has 3 values : Revenue, Expense and ACV. I want to create a list box that only shows Revenue and Expression and I use this expression. "=if(match(Account,'ACV','Revenue'),Account) ". I want to always have one value selected in the list box, but the option seemed to be disabled, even after I select one value in the list box.
Re: "Always One Selected Value" option is disabled when using expression
The problem is that an expression isn't guaranteed to return only one possible value. That's probably why the option is disabled when you use an expression for the listbox. I think you have to create another field in the load script. Or you could create some buttons or text boxes with Select in Field actions assigned to them.