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:
![AnLize_0-1706789936463.png AnLize_0-1706789936463.png](https://community.esri.com/t5/image/serverpage/image-id/93424i6A7C90D5951ECDF6/image-size/medium?v=v2&px=400)
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!