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

       

      Capture.PNG