2 Replies Latest reply: Jul 4, 2012 9:44 AM by Revlin Abbi RSS

    Visual cues not working

      Hi all,

       

      Hope you can help.


      Within a straight table, we can change the backgroud of a cell based on 'Visual cues',  great for highlighting ares of interest in a table. However, in each cell I don't just have a number (say field1) I also have a freq

       

      =avg(field1)
      =avg(field1) & '(' & count(field1) & ')'


      From the above two expressions, I am able to use visual cues for the first but not the second.

       

      Is there any way around this as I really want to include the freq within each cell.

       

      Regards,

       

      Revlin

        • Re: Visual cues not working
          Stefan Wühl

          Visual cues only work with expression that return numericals. Your second expression is returning a string.

           

          But you can use a background color attribute expression (click on the small plus sign next to your expression in expression tab) and enter as defiition something like

           

          =if(avg(field1) < 0, lightred() )

           

          i.e. you must create an expression that returns a color (can also be created using rgb() or argb() functions).

           

          Hope this helps,

          Stefan