Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Prasad Rangu (PrasadRangu)
Instellars
Consultant
Instellars
SG
PrasadRangu Member since 2018 11 posts
Instellars
Posted: Dec 2, 2018
Last activity: Dec 6, 2018
Posted: 2 Dec 2018 11:39 EST
Last activity: 6 Dec 2018 1:38 EST
Closed
Solved

Calculation need to effect entire column of all records

Hi

I have one requirement for entire table column. I created one employee table with 2 columns(Employee Name and Employee Salary) and 3 records(3 Employees and 3 Salaries Amounts) and Same thing I populated in UI as well. I created one separate property with hike percentage and whenever I am updating with some hike percentage and click on the calculate button (provide below hike percentage) will effect all the three employees salaries with new hike percentage.

Please help me in this how to calculate with an example.

Regards,

Prasad R

***Edited by Moderator: Pallavi to update platform capability tags***

To see attachments, please log in.
Case Management
User Experience

Accepted Solution

Posted: 6 years ago
Posted: 3 Dec 2018 8:45 EST
Bhavya Tyagi (Bhavya)
Coforge DPA
Senior Technical Lead
Coforge DPA
GB

Hi

There are 2 ways I can think of:

1. You can use the declare expression on Hike percentage. When that property changes the declare exp should be fired and it updates all the columns. In this case you may not need "Calculate" button.

2. Have an activity on click of calculate, iterate through the list and update the Salaries based on hike percentage.

You can decide for ay of the options depending on how large the data can be as Option 2 may impact performance if the number of employee entries are huge.

Regards

Bhavya

To see attachments, please log in.
Posted: 6 years ago
Posted: 3 Dec 2018 12:48 EST
Prasad Rangu (PrasadRangu)
Instellars
Consultant
Instellars
SG

Hi Bhavya 

Thanks for the help and I am confusing to write the expression or activity for column data.

Could you please give me how to write the activity or declare expression for this.

Regards,

Prasad R

To see attachments, please log in.
Posted: 6 years ago
Posted: 3 Dec 2018 14:36 EST
Rajyalakshmi Bellana (RajyalakshmiB)
NCS Pte Ltd

NCS Pte Ltd
SG

Hi Prasad,

On Click Of Calculate button, Call one Data transform for the salary Calculation.

PFA for Salary calculation and Use EmployeeRevisedSalary property of that Page list for display of increased salary.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice