7 Replies Latest reply on Oct 1, 2018 8:13 AM by meenu choudhary

    Help with formula

    Richard Chandler

      Hello everyone,


      I have a chart that displays the number of records in each status type.  There are only 2 status types, "new" and "accept".  I want to display a 3rd line on this chart that is the number of accept records by the number of new records.



      I cannot figure out how to write a formula using "number of records" but only of a certain status type like this

      Number of records where status = accept / number of records where status = new


      Any help is appreciated! thank you