Conditional Format of Text Object

[#1]

Hi

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?

[rwunderlich · Accepted solution]

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