Nearest achievement and growth

sachin483 · Post by **sachin483** » 22 Nov 2022, 12:38

I have 4 level with 5 criteria grid and i want in which nearest ach% and growth the level has been qualified and ach%

Post by **HansV** » 22 Nov 2022, 12:59

Please explain in more detail what you want.

sachin483 · Post by **sachin483** » 22 Nov 2022, 14:00

I want to evaluate how many levels fall in which grid ie in which criteria they are qualified more for evaluation purpose

Post by **HansV** » 22 Nov 2022, 14:18

I'm sorry, I don't understand.

sachin483 · Post by **sachin483** » 22 Nov 2022, 15:08

I want to pull qualifying levels from the grid to data to see in which level it has qualified

Post by **HansV** » 22 Nov 2022, 15:11

You'll have to provide much more detailed information, and be much more specific. I really don't have the slightest idea what you mean.

sachin483 · Post by **sachin483** » 22 Nov 2022, 15:36

example for level1 ach% 113% & growth is 203648 , hence the nearest qualifying condition from the grid is ach% 110 & growth 160000

data
DIV DESG LEVEL CODE ACH GROWTH
AA LEVEL1 AA7 113 203648

result
NEAREST ACH GROWTH
110 160000

grid
DIVISION DESG ACH growth
AA LEVEL1 120 120000
AA LEVEL1 115 140000
AA LEVEL1 110 160000
AA LEVEL1 105 210000
AA LEVEL1 103 260000

Post by **HansV** » 22 Nov 2022, 15:50

Why is ach% 110 & growth 160000 the "nearest"? What are the criteria?

sachin483 · Post by **sachin483** » 22 Nov 2022, 15:55

example this is the criteria grid out of which 110% & 160000 (3rd line) are the nearest criteria for qualify they can be qualify on other condition but based on ach% nearest

grid
DIVISION DESG ACH growth
AA LEVEL1 120 120000
AA LEVEL1 115 140000
AA LEVEL1 110 160000
AA LEVEL1 105 210000
AA LEVEL1 103 260000

Post by **HansV** » 22 Nov 2022, 15:58

Do we have to match on ACH first and then on growth?
Or do we have to match on growth first and then on ACH?
Or do we need to use a combination of both? If so, how?

sachin483 · Post by **sachin483** » 22 Nov 2022, 16:02

matching will on ach% but with division & desg column for growth i can do vlookup based on ach% combination

Post by **HansV** » 22 Nov 2022, 16:05

If I match ACH=113 to the grid, I would say that 115 is nearer than 110, so I still don't understand why you want 110 as result.

sachin483 · Post by **sachin483** » 22 Nov 2022, 16:14

113 ach% level has achieved on that ,level has qualified on 110% ie a level cannot qualify more than the ach% ie:- level has done 113 ach% so how can he qualifying on 115%

Post by **HansV** » 22 Nov 2022, 16:30

I don't know what your data mean, so I have to keep on asking what the criteria are.
Can we ignore the level when matching?

Eileen's Lounge