Find the occurrence of any record and calculate the column value
Hello,
Ashish here new to PEGA.
My requirement is to find the occurrence of id’s and calculate corresponding column value.
This is Expected result This is the actual data in data table.
PatientID |
Occurrence |
TotalPaid |
P0021 |
3 |
4100 |
P0023 |
2 |
3200 |
P0025 |
1 |
3100 |
P0028 |
1 |
7500 |
PatientID |
TotalPaid |
P0021 |
2100 |
P0023 |
2500 |
P0025 |
3100 |
P0021 |
800 |
P0023 |
700 |
P0021 |
1200 |
P0028 |
7500 |
I tried to use activity that didn't worked. Can any one please suggest how to proceed.
Regards,
Ashish