Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I want to select value2 in a field using Action(in a button) only if the user has not selected any value(before coming to see this report). The report is in a separate sheet, so the user will be coming to this sheet by clicking a button.
Load * INLINE [
Field
value1
value2
value3
];
Below expression not working
if(GetSelectedCount(Field) = 0, 'value2',Field)
Thanks!
use this:
=if(GetSelectedCount(Field)=0,value2,'('&concat(distinct Field,'|')&')')
Regards
Hi @surajap123
IF 2 values are selected, then ur expression won't work. Try like below
=if(GetSelectedCount(Field) = 0, 'value2', '('&concat(Field,'|')&')')