Question
Maantic
IN
Last activity: 6 Dec 2018 1:38 EST
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***
Accepted Solution
Mastek
GB
Maantic
IN
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
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.
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