Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
would an Expression like this would do?
if (count(yourvalue)<5, 'Value to small', yourvalue)
See if the attached sample will work for you....
After Visual Cues, Have you checked from Presentation table. If not, Please check the Suppress when zero values
would an Expression like this would do?
if (count(yourvalue)<5, 'Value to small', yourvalue)
Please check your Dimension Limits
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
Thanks
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))
Its OK. The font color was set to White() and so I couldn't see it.
Thanks anyway.
Greg
Really, Oh okay
I just added enrol instead of this (enrol)