Question

57
Views
Cloe Walker (CloeW938)
IT Solution Service

IT Solution Service
SG
CloeW938 Member since 2018 158 posts
IT Solution Service
Posted: August 11, 2020
Last activity: August 11, 2020
Posted: 11 Aug 2020 7:52 EDT
Last activity: 11 Aug 2020 8:59 EDT

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.

RD

Thanks,

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

Pega Platform 8.4 Reporting