3 Replies Latest reply on Apr 18, 2013 4:41 AM by Robert Bell

    Can I make a shape transparent or invisible if it is derived from a value of null or 0?

    Robert Bell

      Hi

      Please see the attached twbx. We have coloured shapes (green 'up' and red 'down' arrows) to indicate where a measure has increased or decreased on the previous year. What we can't figure out is how to show nothing if there is no increase or a null value. We've used a calculated field to determine teh shape and colour but there doesn't seem to be a white colour to pick from the 'edit colours' option to hide the shape (against our white background) and of course the transparency slider will apply to all values. The best we can do is an off-white circle! (see UCAS on the offer trend by level view).

       

      Can anyone help?

       

      Thanks

       

      Bob