If you look at your IR / IR_Points data, you only get IR_Points where your fourth decimal digit of the fractional part is zero.
Since you are using a join in your table load and I can't see the original excel table with the mapping of IR to IR Points, I am only guessing:
Does your mapping table holds only IR data with 3 decimal digits of the fractional part?
If yes, you can try changing your line
Round(1-((UR)/(IR_Calls)),-.0001) AS IR
Round(1-((UR)/(IR_Calls)),-.001) AS IR
If not, I think a join is not the appropriate method to map your calculated IR values to the lookup values, a join is only mapping exactely matching (in this case numerical) values, i.e. it will match 1.2340 to 1.234 because they numerically match (assuming they have the same internal floating point representation), but not 1.2341 to 1.234.
Hope this helps,
Hm, not sure if there is a better solution, a join seems ok to me.
It would be good to see the excel file that you want to join, do you mind uploading it?
And if you say, you are not getting the results you want, what exactely do you get (having changed what compared to your last file), and what do you expect?
I used (Round(1-((UR)/(IR_Calls)),-.001) AS IR and I am still missing points for some reps. What I would like to have are points for each IR value, for each rep. I attached the excel file for your reference.
Leveling v1.xlsx 74.4 K