Hide a field from a LISTBOX

[fanninam]

Need to hide a field from a LISTBOX. For example, I want to not show 2027 (they used it as a test year).

[pradosh_thakur · Accepted solution]

if(Yourfield<>2027,Yourfield)

[pradosh_thakur · Accepted solution]

IF(Your_field =2027,null(),Your_field)

or

pick(Match(Your_field,2027)+1,Your_field,null())

[sunny_talwar]

Another option

Aggr(Only({1<Year = e({<Year = {2027}>})>}) Year), Year)

[mayank_daga]

Try this:

AGGR(CONCAT({1<Year-={'2027'}>} Year), Year)

[sunny_talwar]

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

[mayank_daga]

Yes, I'm sorry. Typo.. using a mobile to answer!