CloeW938 Member since 2018 145 posts
IT Solution Service
Posted: August 11, 2020
Last activity: August 11, 2020

Doubt about count with Join (Report Definition)

Let's say, I have a Food Expense work objects as below.

Food Expenses

.ParticipantList is a Page List that includes information about who participated and how much they spent. These fields are optimized and I already have an Index table. From this table, I would like to make a below outcome with a Report Definition. Expense Total will be calculated from the total within a case by joining with Index table.

Food Expenses2

How can I make this? When I tried below configuration, expense total is correct, but # of WO is wrong. It seems to give # of rows that are joined per Type. I would like to simply get the number of WO, regardless of Index table. It works fine if I remove Joined column, but when I add it back, it gives me wrong number.



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

Pega Platform 8.4 Reporting
Share this page LinkedIn