Nearest achievement and growth
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Nearest achievement and growth
I have 4 level with 5 criteria grid and i want in which nearest ach% and growth the level has been qualified and ach%
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Re: Nearest achievement and growth
I want to evaluate how many levels fall in which grid ie in which criteria they are qualified more for evaluation purpose
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Re: Nearest achievement and growth
I want to pull qualifying levels from the grid to data to see in which level it has qualified
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Nearest achievement and growth
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.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Nearest achievement and growth
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
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
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Nearest achievement and growth
Why is ach% 110 & growth 160000 the "nearest"? What are the criteria?
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Re: Nearest achievement and growth
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
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
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Nearest achievement and growth
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?
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?
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Nearest achievement and growth
matching will on ach% but with division & desg column for growth i can do vlookup based on ach% combination
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Nearest achievement and growth
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.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Nearest achievement and growth
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%
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Nearest achievement and growth
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?
Can we ignore the level when matching?
Best wishes,
Hans
Hans