Hide some values in multi box

[Anonymous]

hi every one,

my requirement is to hide some values in multi box.

iam trying one format but its not working .

=aggr(only({<HourOffset-={'<0'}>}HourOffset),HourOffset)

my data is like this

HourOffSet <0

                    0-12

                    12-24

                    24-48

                    >48

i dont want to display <0 and >48 values in multi-box.

thank in advance

[sunny_talwar · Accepted solution]

May be like this

If(not WildMatch(HourOffSet, '*>*', '*>*'), HourOffSet)

[sunny_talwar]

Or this

=Aggr(Only({1<HourOffset - = {'*<*', '*>*'}>} HourOffset), HourOffset)

[maxgro]

=If(WildMatch(HourOffSet, '*-*'), HourOffSet)