7 Replies Latest reply: Sep 16, 2009 5:05 PM by John Lewis RSS

    Excluding records in chart based on expression

      Is there a way to exclude records from appearing in a chart based on the result of other expressions in that chart and not have that records values included in the chart totals?

      In the example I attached, I want to exclude the item "77777" when the EnterDate is 4/30/2009 because that record has 0 for the "Avg Investment" and "Sales" expressions. I guess because the chart is using a Set Expression to look for all records that have a value that match the EnterDate it is including item "77777". If I try to exclude it in an IF statement, the chart does not show the item but the value is still included in the chart total.

      Any ideas?

      Thanks for your help.