Conditional Format of Text Object

Mon, 24 Nov 2014 03:12:54 GMT

I have a text object which is counting records

=Count({<[ResidualRisk] = {25}>} Reference)

I want to hide the text of the object but not the background if the count = 0

Any suggestions on how to do this?

Re: Conditional Format of Text Object

rwunderlich — Mon, 24 Nov 2014 03:38:07 GMT

Use a conditional to display a blank or a value for the text:

=if(

Count({<[ResidualRisk] = {25}>} Reference)=0

,''

,Count({<[ResidualRisk] = {25}>} Reference)

)

If you just have a number, another way is to use the third num format parm as blank for zero like this:

=num(Count({<[ResidualRisk] = {25}>} Reference),'0;;')

-Rob