1 Reply Latest reply on Jun 6, 2018 9:39 AM by Deepak Rai

    Multiplying 2 measures where 1 measure is derived from a different criteria of the same dimension

    Shahab Heidari

      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?