Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
If(not WildMatch(HourOffSet, '*>*', '*>*'), HourOffSet)
May be like this
If(not WildMatch(HourOffSet, '*>*', '*>*'), HourOffSet)
Or this
=Aggr(Only({1<HourOffset - = {'*<*', '*>*'}>} HourOffset), HourOffset)
=If(WildMatch(HourOffSet, '*-*'), HourOffSet)