Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How can I only show subregions called 'Logan' or 'Beaudesert' in a table?
The below isn't working -
=if([SubRegion]='Logan' or
[SubRegion]='Beaudesert',
[SubRegion])
Thanks
for exemple for this input :
you can use this expression :
=if(Match(SubRegion,'Logan','Beaudesert')>0,SubRegion)
output:
and Supress when Value is Null
you can use also wildmatch