4 Replies Latest reply on Jun 8, 2018 8:03 AM by Harshil Sutaria

    Lookup and Fixed

    Nishanth Reddy

      Hello :

       

      I've details of 10000 employees repeated for every month, with Month being a column value. So the first 10K correspond to January and the Second 10K correspond to Feb and so on. There can be additions/deletions of employee records based on the number of hires and terminations. I've a column for the 'Employee level' ranging from '1' to '7'. These numbers convey the designation of employees. I'm trying to create a calculated column to see if there is a change in employee designation month over month.

       

      I'm usimg the following expression:

       

      { fixed [emplid] : lookup(ATTR(employeelevel,-1)}. This is incorrect as I'm using ATTR in FIXED LOD. is there a way to modify this expression ?

       

      Thanks

      Nishanth