2 Replies Latest reply on Feb 8, 2017 5:28 AM by Gregg Hirshberg

    Reference Line of an Average Percent

    Gregg Hirshberg

      I have a dashboard (dashboard 1) attached. And I need it to have 4 reference lines. 1 for 2016 Pos Verification Avg, 1 for 2015 Pos Verification Avg, 1 for 2015 Verification % and 1 for 2016 Verification %.

       

      Problem is, with the formula I've been able to think of, Pos Verification % avg for the time period, isn't the actual avg %, but the avg of each month. So instead of having 2460/2881 for 85.4%, it shows up as 85.6%. I'm sure it's a simple solution that I'm just overlooking. Thanks in advance for your help!