7 Replies Latest reply: Apr 26, 2017 10:59 AM by Cliff Clayman RSS

    How to get a count of a field for a Pie Chart with specific criteria

    Cliff Clayman

      I am trying to get a count of IDs that meet a specific set of criteria for a Pie chart.  The criteria is:

       

      Sum(Charges) < 5 and Sum(ChargeAmount) < 1000 and FY = vCurrent

       

      I need a Count of the GID field when this criteria is met.