Compare numbers in different modules
I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised)
The other module (emp module) has projected attainment % for each employee (like below)
We need to compare the Attainment in 2nd screenshot to the Achievement(which is a range) in the 1st screenshot to pull the payout % from Screenshot 1 to 2.