Need Calc Help

sagarkpr
edited December 2022 in Modeling

Hi Community,


I am working on this use case. Wondering if this is possible.

 

DAT01 Emp Details

Emp | Start Rate

EmpA  15

EmpB 16

EmpC 17

 

SYS02 Zone Module

Zone| Lower Range | Upper Range

ZoneA    14                 15

Zone B   15                 16

Zone C   17                 100

 

How can I identify which Zone does an employee falls in.

 

Final result needed

Emp | Zone

EmpA  Zone A

EmpB Zone B

EmpC Zone C

 

Any ideas?

 

Best Answer

Answers