Hi all,
I'm trying to roughly match values in my data. My company has an internal bill rate for internal reporting and then we invoice clients via an external bill rate depending on our market location. I have a key that matches the internal rate with the external rate but our timekeeper system has a larger variety of rates due to people working all over the country at different internal rates. I'm trying to approximately match the actual internal rate in a large set of WIP data with an internal rate in my key. At the end of the day, I want to be able to match any internal rate that is not zero with the closest external rate.
Thank you!
