Dashboard Indicator with Reference and Advanced Formatting

aprhyde11 — Tue, 11 Mar 2025 17:04:21 GMT

I'm needing to add the Estimated, Actual, and Differences for my data in an Indicator.

Under the Data tab, I have the Actual Cost set up as a reference to the Estimated Cost. Everything works fine unless the Actual Cost is Null, in that case the Indicator reads "No Data". I need it to read the Estimated Cost: $###, Actual Cost: $0 , and Difference: $0

This is the expression I'm using:

var totalOverall = $datapoint.SUM_TOTAL_OVERALL; // Your default field var totalRepairCost = $reference.SUM_TOTAL_REPAIR_COST; // Your alternate field // If totalRepairCost (actual) is null or empty, set it to 0 var actual = IIf(IsEmpty(totalRepairCost) || totalRepairCost == null, 0, totalRepairCost); // Round up to the nearest whole number totalOverall = Ceil(totalOverall); actual = Ceil(actual); // Calculate the difference (set to 0 if actual is 0) var difference = IIf(actual == 0, 0, Ceil(totalOverall - actual)); // Format the numbers with thousand separators var formattedTotalOverall = Text(totalOverall, '#,##0'); var formattedActual = Text(actual, '#,##0'); var formattedDifference = Text(difference, '#,##0'); return { // Text for the "Estimated" value topText: 'Estimated: $' + formattedTotalOverall, topTextColor: '', topTextOutlineColor: '', topTextMaxSize: 'medium', // Only show "Actual" and "Difference" if actual is not 0 middleText: IIf(actual != 0, 'Actual: $' + formattedActual, ''), middleTextColor: '', middleTextOutlineColor: '', middleTextMaxSize: 'large', bottomText: IIf(actual != 0, 'Difference: $' + formattedDifference, ''), bottomTextColor: '', bottomTextOutlineColor: '', bottomTextMaxSize: 'x-small', // Ensure no "No Data" message is shown noValue: false }

I realize it's a bit overcomplicated at the moment, but it's working for the most part.

How do I get the Indicator to still show data when Actual Cost = Null?

Thanks for the help!

Re: Dashboard Indicator with Reference and Advanced Formatting

StephanieSimpson2 — Tue, 23 Sep 2025 20:33:37 GMT

Hey, did you ever solve this? I'm having the same issue.

topic Dashboard Indicator with Reference and Advanced Formatting in ArcGIS Dashboards Questions

Dashboard Indicator with Reference and Advanced Formatting

Re: Dashboard Indicator with Reference and Advanced Formatting