17 Replies Latest reply: May 19, 2011 8:26 AM by Goran Korsgren RSS

    Formatting text in expresssion

    Paul Kelly

      Hi All

       

      I have a pivot table that looks something like...

       

      CustomerMayApril
      ASales0100
      Margin050
      BSales75100
      Margin3550

       

      Sales formula = Sum(sin_Sales)

      GP formula = Sum(sin_GrossProfit)

       

      What I want to do is show the zeros as a blank...

       

      To do this, I visited the expresssion for each and keyed the following into the text colour property of the expression...

       

      Sales .... =if(sum(sin_Sales) = 0, RGB(255,255,255))

      GP........ =if(sum(sin_GrossProfit) =0, RGB(255,255,255))

       

      What I end up with howver, is as follows...

       

      CustomerMayApril
      A100
      50
      BSales75100
      Margin3550

       

      i.e. If the customer has no sales in the most recent month, it blanks out the values but also blanks out the row descriptor...

       

      Is this a bug or should I be doing something different to achieve what I want?

       

      Thanks in advance for any help you guys can give...

       

      Regards

      Paul