Greetings, I need help with a formula - I'm having trouble wrapping my mind around it. I'll explain the variables below, and any assistance is appreciated.
There are two variables
Vendors (This is a dimension, but I'm going to want a distinct count)
Spend ($)
There is a spend figure associated with each vendor, and I want to find out the average number of vendors per $1M of spend.
The entire spend is about $88 million, and if needed, dividing by 88.12 gets the spend data into $1M sets.
This might be elementary for some, but not getting it.
Thanks in advance for the help.
-Jocelyn
Following is an example that uses the metrics to which I was referring (I used your first name in the metric examples). You can download the file to see the details.
