Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need to hide a field from a LISTBOX. For example, I want to not show 2027 (they used it as a test year).
IF(Your_field =2027,null(),Your_field)
or
pick(Match(Your_field,2027)+1,Your_field,null())
IF(Your_field =2027,null(),Your_field)
or
pick(Match(Your_field,2027)+1,Your_field,null())
Another option
Aggr(Only({1<Year = e({<Year = {2027}>})>}) Year), Year)
The problem is that as soon as your select a Year, the other Years will vanish. May be you wanted this
AGGR(CONCAT({1<Year=-{'2027'}>} Year), Year)
minus sign after = and not before