I'm working with pay planning data and need to apply a geo-based differential to the market data. The logic is:
If a person resides in the west region, their differential should be 95% of the East region's market mid-point value. I'm struggling with how to write out the expression. This is my code but it's only applying it to employees who already reside in the East.
[Geo Differential] * (CASE [Geo] WHEN 'East' THEN [Mkt P50] END)
I'm wondering if I need to use an LOD, but not sure. Any tips?
Can you provide some fake data and your expected result?