I am attempting to add a Summary Statistic to a Report that would be the SUM of Total Costs 'Where' the Project Year was X.
I am able to add the summary statistic to the report for total costs, but so far, I have only been able to directly reference an attribute, and sum that entire attribute, and not filter it based on another attribute.
I was thinking something like this, but I am sure my formatting is wrong because it doesn't work:
<dyn type="report" property="field-sum" mapMemberUri="CIMPATH=inset_locator/tip_projects_primary.json" sql="Prelim_Engineering_Year = '2024-01-01 00:00:00'" field="CIP.TIP_Master.Total_Cost"/>
I've borrowed some of the formatting from an Insert Table Attribute text view (which doesn't make itself available when on the Reporting tab) to get the 'where' aspect.
Essentially, I am hoping someone can help me implant the correctly formatted 'where' statement into the 'Text View' of a Dynamic Element.
Windows 10
ArcGIS Pro 3.2.1
Matt Reeves