Forum Discussion

Arul's avatar
Arul
Icon for Super User rankSuper User
5 years ago
Solved

New Column Derivation

Hi all,

I have table like below, wherein I need to create new column based on the value in Final RM Level. I need to get the value from respective column and need to put into new column.

 

Thanks,

-Arul

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Arul , a new column like

     

    new column =
    Switch ( [Final RM Level],
    "RM1",[RM1],
    "RM2",[RM2],
    "RM3",[RM3],
    "RM4",[RM4],
    "RM5",[RM5]
    )

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Arul , the logic is not very clear.

     

    I thought of , but that if not work 

    RM1 = if([final RM Level] = "RM1",[self score] , 0)

    • Arul's avatar
      Arul
      Icon for Super User rankSuper User
      5 years ago

      amitchandak ,

      It does not helps. I'm looking for single column for the given value in the final RM column for each row as a new column.

       

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        Arul , I am clear on the logic. I have just given the formula that can be possibly there based on the description.

         

        Please explain me logic of output column, I will try the formula