6 Replies Latest reply: Feb 8, 2018 5:14 AM by omar bensalem RSS

    Exclude certain records in a chart?

    Stephen Hasson

      Hi,

       

      I have a bar chart  which has an expression  "sum(ReceivedToStockQty)/Sum(ProdQty)" to show the percentage of stock received vs expected.

       

      It works fine, but i'd like to remove anything where the percentage is 100% (or ratio is 1 I guess), but can't figure out the syntax in set analysis / if statement to achieve this.

       

      Thanks.