Hiding cells in a table when the value is less than 5

[Anonymous]

I am trying to hide cells in a table when the value is less than five.

I have tried visual cue to highlight cell values less than five with a colour but I would like to be able to hide the value or replace it with a note that says the numbers are too small to show.

Any suggestions?

Thanks

Greg

[trdandamudi]

See if the attached sample will work for you....

[Anil_Babu_Samineni]

After Visual Cues, Have you checked from Presentation table. If not, Please check the Suppress when zero values

[Anonymous · Accepted solution]

would an Expression like this would do?

if (count(yourvalue)<5, 'Value to small', yourvalue)

[Clever_Anjos]

Please check your Dimension Limits

[Anonymous]

Thanks.

This works well with a simple expression but when I try to use the same principles on a more complicated expression it hasn't worked properly for me (probably because my expression is wrong?).

=if(Count({$<Year=, Pi={'YES'}, simd10={'Y'}, level={'FE'}, mode_study= {'Full-Time'}>}(enrol))<5, 'Value too low', Count({$<Year=, Pi={'YES'}, simd10={'Y'}, level={'FE'}, mode_study= {'Full-Time'}, Pi_outcome={'Completed successful'}>}(enrol))/Count({$<Year=, Pi={'YES'}, simd10={'Y'}, level={'FE'}, mode_study= {'Full-Time'}, Pi_outcome={'Completed successful','Completed partial success','Early_withdrawal','Further withdrawal'}>}(enrol)))

When I use the above expression it blanks out the values instead of using my suggested text 'Values too low'.  Any idea what I'm doing wrong?

Thanks

Greg

[Anonymous]

Thanks

[Anil_Babu_Samineni]

Can you please post application

Try This...!

=if(

     Count({$<Year=, Pi={'YES'}, simd10={'Y'}, level={'FE'}, mode_study= {'Full-Time'}>} enrol)<5, 'Value too low',

     Count({$<Year=,Pi={'YES'}, simd10={'Y'}, level={'FE'}, mode_study= {'Full-Time'}, Pi_outcome={'Completed successful'}>} enrol)/

     Count({$<Year=,Pi={'YES'}, simd10={'Y'}, level={'FE'}, mode_study= {'Full-Time'}, Pi_outcome={'Completed successful','Completed partial success','Early_withdrawal','Further withdrawal'}>} enrol))

[Anonymous]

Its OK.  The font color was set to White() and so I couldn't see it.

Thanks anyway.

Greg

[Anil_Babu_Samineni]

Really, Oh okay

I just added enrol instead of this (enrol)