Reports :: To get Sum of Grand Child Table Txns

AppSheet AppSheet Q&A
1

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

3X_2_4_24674e139841d6874d795fcdaac7787df65c6fc3.png
3X_2_4_24674e139841d6874d795fcdaac7787df65c6fc3.png902×236 55.9 KB

3X_2_9_291207c1303d195448e8fbb65618fbc2b010bc8b.jpeg
3X_2_9_291207c1303d195448e8fbb65618fbc2b010bc8b.jpeg902×236 43.5 KB

3X_f_e_fe3058e9e9bd1e27fb3b2baa15aac9155576de77.jpeg
3X_f_e_fe3058e9e9bd1e27fb3b2baa15aac9155576de77.jpeg902×642 64.9 KB

3X_9_a_9aa8130e0450255a8f654c21af88ea805eba2be1.jpeg
3X_9_a_9aa8130e0450255a8f654c21af88ea805eba2be1.jpeg902×642 37 KB

2

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

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

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

4

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

5

Thank you @Steve, let me check again.

Regards,
Senthil

1 Like