Conditionally Show Sheet count of field greater than Zero

[ivandrago]

Hi,

I have the attached Document, I only want the sheet "Show Me" to appear if the Field "_Area Flag" has a value greater than zero when a Selection is made, if the values is equal to zero I do not want this sheet to appear.

Thanks

[YoussefBelloum]

Hi,

put this on the conditional display of that sheet:

=GetSelectedCount(_AreaFlag)<>0 and GetFieldSelections(_AreaFlag)>0

[big_dreams]

Hi,

go to sheet property > general > conditional > write below expression

=if(GetFieldSelections(_AreaFlag)>0 and GetSelectedCount(_AreaFlag)=1,1,0)

Regards

[ivandrago]

Thanks for your reply.

This works but only if you select the field _AreaFlag i.e. if I select the value 1, but I want it to work on any field selected as long as the total count for that field is greater than 0.

[juliensaintmaxent3113]

Hi,

on the sheet which apperas vhen you select a value, you enter in propertie and you write this :

=sum(_AreaFlag)>0 and not isnull(GetCurrentSelections())

have a nice day

[big_dreams]

try below

=if(sum(DISTINCT _AreaFlag)>0,1,0)

regards,

[YoussefBelloum]

try this:

=if(wildmatch(GetCurrentSelections(),'*'),1,0)

[tresesco]

I guess, you could try something like:

=SubStringcount(GetCurrentSelections('',',') ,',')

With this you can get actually how many values from different fields are selected.

[ivandrago]

Doesn't work I'm afraid

[ivandrago]

Doesn't work I'm afraid