4 Replies Latest reply on Feb 12, 2018 2:59 PM by Amirah Thompson

    Created Calculation, Possible Null- Individual Scorecard

    Amirah Thompson

      I have two fields that I need to compare to one another to create a monthly performance metric. Yes and No are give, and the Transfer Rate option was built as a formula.

       

      Example - the 600% should be: 33/36 = 91.67%.

       

      Should something else be built into the formula?

       

      I also tried:

       

      ATTR: Yes Inquiry/ Yes Inqy+No Inquiry, this turns the formula to AGG and gives me incorrect values as well.

       

      Here is the original data:

       

      Is it possible that the nulls are affecting the formula?