Forum Discussion

Fromero's avatar
Fromero
New Contributor
3 months ago

Adding a new column to People Planning

Hello, When working in Workflows > Budget scenario, I would like to add a new column in People Planning that would depict new annual salary after discretionary merit increase. Any idea's?

  • T_Kress's avatar
    T_Kress
    Contributor III

    When you say add a new column, have you gone in to your People Planning Register Field List settings and checked the "Visble" to add in that new column?  And then write logic to populate that column?

     

    • Fromero's avatar
      Fromero
      New Contributor

      Okay, I added the two new fields based on the snip above. I would now like to add the logic ( Annual Salary x 1.03 ) and ( Annuals Salary_2 x 1.n ). Where does one write this calculation?

      • T_Kress's avatar
        T_Kress
        Contributor III

        In the calc definitions section of PLP:

         

  • Fromero's avatar
    Fromero
    New Contributor

    I will take a look now, because I don't know what to do on the Calculation page, Thanks

    • DanielWillis's avatar
      DanielWillis
      Valued Contributor

      The calculation definitions page is for writing calculations that will ultimately get pushed to the cube and not for calculating fields stored in the register table. The output is written to the Plan Data tab (going from memory on the name). It sounds like you actually want to see this calculated field as a value in the initial register table?

      • Fromero's avatar
        Fromero
        New Contributor

        Hello! Yes (  It sounds like you actually want to see this calculated field as a value in the initial register table ). I ultimately want to multiply my Annual Salary by Standard merit (.03) and see result, then multiply AS by additional merit ( .07) and see result, then last col. would depict the new budget Annual Salary 🙂

  • Fromero's avatar
    Fromero
    New Contributor

    I'll take a look now, much appreciated! ğŸ˜‰