We are developing a summary report for a client where they need to submit the sum of Estimated Costs (Value field in the feature service) for certain permit types to the county every month.
They want there to be a $ before the sum, so we put that in front of the field, however, the report lists all permit types available in their survey, so there will be months where some permit types were not applied for. Because of that, when a permit is not applied for in a given month, there's a floating $ in the report which they wanted to not happen.
So, we developed an aggregate script where the $ will only show up if there are permits, aka the TotalValue is greater than 0. This is working with no issues:
${#FeatureService | stats:"sum,Value,TotalValue" | where:"Type='BUILDING' AND Class='Commercial_Acc_Structure'"} ${if TotalValue > 0}$${TotalValue}${/}${/}
Additionally, though, they need to show 2 decimal places. This formatting is not working. We did not get errors when pushing it to Survey123, but it did not generate to 2 decimals. This is how the above script was modified:
${#FeatureService | stats:"sum,Value,TotalValue" | where:"Type='BUILDING' AND Class='Commercial_Acc_Structure'"} ${if TotalValue > 0}$${TotalValue | format: "#,###.##"}${/}${/}
