Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
IF("Movement Type"='Promotion Band Up','Implemented' , IF("Movement Type"='Promotion Within Band','Not Implemented' , IF("Movement Type"='Lateral Move','Not Implemented' , IF(isnull("Movement Type"), 'Not Implemented' , IF("Movement Type"='Termination Voluntary','Not Implemented', IF("Movement Type"='Termination Involuntary', 'Not Implemented')))))) as "4A Implementation",
With this code I define an implementation of something.
As my source files I have: Employee report and Movement Report.
Because I load my movement script concatenated, every person that has a movement has 1 line from the movement report, and 1 line from the employee report.
The line from the employee report will be blank where the movement report will show a movement.
I now want to implement this implementation script, that it looks if a value is already present from the movement script, and then will show implemented in both the employee report line and movement report line.
As you can see in the picture, the first line for example, is the same person. She already has 1 implemented line, her other line should then also say implemented.
Try the match function, this might be a better way to do this together with the pick function.
Alright, thanks. I understand.
But it unfortunately does not solve my issue.
What I need it to do now, is see if there is a previous implemented value assigned to an ID, and then fill in the blanks with implemented too.
So as example:
The red lines should also say implemented.
But in the case of Ekaterin, it should say not implemented, as she does not have a movement at all.