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

[ivandrago]

Doesn't work I'm afraid

[ivandrago]

Doesn't work I'm afraid

[YoussefBelloum]

what is missing on this app ?

[big_dreams]

what do you mean doesn't work??

can explain little bit more?

Regards,

[ivandrago]

If you look at the attached, it is selecting NewTableName = "dbo.BSsignedUserAliBS" the Text box is showing that there is no _AreaFlag greater than 0 but the Sheet "Show Me" appears, it should only appearing when that value in the Text Box is greater than 0.

[sunny_talwar · Accepted solution]

May be this

=Len(Trim(GetCurrentSelections())) > 0 and _AreaFlag > 0

[tresesco]

You can use the same (as in textbox) expression as the conditional expression of the sheet.

=sum( {$<[_AreaFlag]={'1'}>} [_AreaFlag])

[YoussefBelloum]

ok,

this should work for you

=if(wildmatch(GetCurrentSelections(),'*'),1,0) and Concat(DISTINCT _AreaFlag)=1

PFA

[sasiparupudi1]

May be try

=(Index(GetCurrentSelections(','),'_AreaFlag: 1')>0 AND Index(GetCurrentSelections(','),'_AreaFlag: 1')<Len(GetCurrentSelections(',')))

[big_dreams]

did you try my suggestion???

where are your putting those expresssion??

it should be in show me sheet > property > general > conditional >

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

Regards