Skip to main content
October 8, 2024

Adding a new column to People Planning

  • October 8, 2024
  • 3 replies
  • 0 views

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?

3 replies

October 8, 2024

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?


T_Kress_0-1728419562118.png

 

FromeroAuthor
October 8, 2024

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?

October 8, 2024

In the calc definitions section of PLP:


T_Kress_0-1728421563206.png

 

FromeroAuthor
October 9, 2024

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

Employee
October 11, 2024

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?

FromeroAuthor
October 11, 2024

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 🙂

FromeroAuthor
October 14, 2024

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