Discussion

1
Replies
248
Views
AshishR6 Member since 2014 4 posts
Syntel Ltd.
Posted: 5 years ago
Last activity: 5 years 4 months ago
Closed

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

Reporting
Moderation Team has archived post
Share this page LinkedIn