4 Replies Latest reply: Jun 20, 2011 8:09 AM by Jonathan Dienst RSS

    Hiding values in chart

    Chris Hopkins

      Hi, I am trying to hide some values within a straight table.

      I have 2 straight tables:

       

      Goods Received

      Goods Returned

       

      Goods receiving figures are all POSITIVE values and goods returned are all NEGATIVE values.

      The problem i have is that the only way i can tell what is returned and what is received is by looking at the values.

      I want to be able to show ONLY POSITIVE vales in the goods received table and ONLY NEGATIVE values in the goods returned table.

      I have tried writing a simple expression for each table

      i.e.

      If(sum(StockQty)>0,StockQty)

       

      StockQty is my value field.

       

      But this still shows the details for the negative lines (but hides the actual value) is there a way i can completely hide the full line for negative values on Goods Receiving and hide the complete line for positive vales on the Goods Returned table?

       

       

      I have attached a sample

       

      Thanks for your help.

       

      Chris