if all 4 qtr is >= 100 then 20000 , if any 3 qtr > 100 and anl > 105 ach% , then 20000 after matching col1 and col2 with the grid
<tbody>
</tbody>
grid | |||||||
col1 | AA | A | B | C | ANL | ||
XX | 25000 | 20000 | 16500 | 13000 | 105 | ||
YY | 20000 | 17000 | 14500 | 12000 | 110 | ||
data | |||||||
col1 | col2 | QTR1 | QTR2 | QTR3 | QTR4 | ANL | Amount |
XX | A | 84 | 124 | 111 | 108 | 106 | 20000 |
XX | A | 108 | 101 | 113 | 109 | 108 | 20000 |
XX | A | 104 | 112 | 103 | 109 | 107 | 20000 |
XX | A | 104 | 105 | 109 | 85 | 101 | 0 |
XX | AA | 93 | 133 | 110 | 110 | 111 | |
XX | AA | 100 | 122 | 112 | 94 | 107 | |
XX | B | 68 | 133 | 114 | 115 | 107 | 16500 |
XX | B | 101 | 114 | 108 | 105 | 107 | |
XX | C | 103 | 117 | 118 | 105 | 111 | 13000 |
XX | C | 85 | 119 | 115 | 112 | 108 | |
YY | A | 85 | 125 | 112 | 109 | 108 | |
YY | A | 109 | 102 | 114 | 110 | 109 | |
YY | A | 105 | 113 | 104 | 110 | 108 | |
YY | A | 100 | 119 | 127 | 86 | 108 | |
YY | AA | 94 | 134 | 111 | 111 | 113 | |
YY | AA | 101 | 123 | 113 | 95 | 108 | |
YY | B | 69 | 134 | 115 | 116 | 109 | |
YY | B | 102 | 115 | 109 | 106 | 108 | |
YY | C | 104 | 118 | 119 | 106 | 112 | |
YY | C | 86 | 120 | 116 | 113 | 109 |
<tbody>
</tbody>