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?