Insert Statistic Value into Report with a conditional Where type statement

MattReeves_SpokaneValley — Tue, 26 Mar 2024 00:10:29 GMT

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:

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

topic Insert Statistic Value into Report with a conditional Where type statement in ArcGIS Pro Questions

Insert Statistic Value into Report with a conditional Where type statement