Reports :: To get Sum of Grand Child Table Txns

Good Evening All,

I have 3 tables, DivisionalOffice -> Resellers -> CampaignTxn. End of every month, a report need to be generated on

  1. Each Division wise
    a. how many resellers participated in a campaign (based on CampaignTxn data ) in a division
    b. How many campaign on each division.

The campaignTxn has all transactions and has link to resellers table using resellerID

Based on the Ive setup a report format, still is not giving me the expected result. Attached below the report template format/Report sample.

Thanks,
Senthil

In the Total no of QLOCs column of the template, try this expression:

<<COUNT([Related tblResellers][Related tblCustomerQLOCs])>>
1 Like

Thank for your quick input @Steve, as always. I tried and it didn’t work. As of now, added virtual column tblResellers to have campaign count.

The error message is
Expression ‘COUNT([Related tblResellers][RelatedtblCustomerQLOCs])’ is invalid due to: Unable to find column ‘RelatedtblCustomerQLOCs’

Thanks,
Senthil

I’ve adjusted my suggested above. Please try the revised expression.

Thank you @Steve, let me check again.

Regards,
Senthil

1 Like