This content has been marked as final. Show 2 replies
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!