Survey123 Report Template: sum of sums
Hello the Community!
I'm working on a Survey123 process involving the inspection of properties in order to allocate grants. In my data model, I have one Application, under which for 10 categories one would find different work items with associated costs. So Application > Repeat "ApplicationCategory" > nested repeat "ApplicationCategoryCosts"
In a report template, I am trying to summarize all those costs (for one application, so working on a single record). I can display a table with the totals per category:
Category
| Applicants Quotation Costs | Inspectors Allocated Costs | Applicants Invoiced Costs | Inspectors Final Costs |
${#ApplicationCategory}${#ApplicationCategoryCosts | stats:"sum,QuotationCost,CatQuotationCosts; sum, AllocatedCost,CatAllocatedCosts ; sum,InvoicedCost,CatInvoicedCosts ; sum,FinalCost,CatFinalCosts "}Category ${ ApplicationCategory.CategoryNo} | €${CatQuotationCosts} | €${CatAllocatedCosts} | €${CatInvoicedCosts} | €${CatFinalCosts}${/}${/} |
This displays well a nice table with all summed costs per categories:
Where I am hitting a wall, is trying to display a grand total row. So for the 4 cost column, sum up the category sums. Any idea how I could achieve this?
Thanks for your help!
