Skip to Content

Showing In Line Manger for Employee

920.pngDear Experts,

We have to add a column to show if that particular employee is In Line Manager or not by a Character X..

From the below screen shot, I've shown that how this is to be calculated in webi report. We are on 4.2 SP4.

I used formula but was not able to get correct results. What is wronig ?

=If[SAP Personnel nr]=[Line manager SAP nr] Then"'X"

920.png (39.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 30 at 07:22 AM

    Experts, any pointer on the above. I need solution urgently.

    Add comment
    10|10000 characters needed characters exceeded

  • May 02 at 06:56 AM

    920-2.pngThanks for your inputs Jyoti,

    From the fig attached 920.png, for employee 10015288, this employees id is appearing in the Line Manager's personnel id.Hence, this employee is designated as Line Manager which need to be shown by character symbol 'X'.
    In the above instance, the line manager's id is appearing above which may not be the case as in this employee which is 10015215.
    For this employee, the Line Manager's personnel id appears much below (Basically :: It can occur any where in the column)
    So, we need to do a vlookup thing and designate the employee if his/her id appears in Line Manager's column and represent it with 'X'.

    I tried using "Results from another query" option in which this first query is taking just the Line Manager Id from another data provider but it is not working as desired results are not obtained Refer 920-1 and 920-2920-1.png .

    Could you please help me overcoming this issue ?920.png

    Your inputs are highly appreciated

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 30 at 07:51 PM

    Hi,

    What is the criteria of Personnel # and Line Manager #?.

    If both match then display text?. How is your Employee table has Line Manager designated as?,

    Post a sample data. May be that helps. your question is vague.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded