Doubt about count with Join (Report Definition)
Let's say, I have a Food Expense work objects as below.
.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.
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.
Thanks,
***Edited by Moderator: Pallavi to update platform capability tags***