duranimal86
New Member
- Joined
- Jul 24, 2019
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
I am creating a dashboard to display some calculated metrics. I have a detail with thousands of lines of submitted invoices. I have pulled out the Creation Dates, User, and the number of invoices submitted (by day and user), and I am trying to do some user level comparisons. I have been able to calculate the average # of invoices per day (# of invoices submitted/# of users submitting invoices) and I have that shown in a matrix that has the average for the day, but each user line just has their # of invoices. My end goal is to compare the # of invoices submitted by each user to the average for the date, either in the same calculated column or separately, but i can't figure out the right formula.
Currently I have:
I would like to get to something below where I can calculate the user # for the day minus the average for the day:
Currently I have:
I would like to get to something below where I can calculate the user # for the day minus the average for the day: