topic Re: Dynamic Text Expression Returns Null Instead of 0 in ArcGIS Experience Builder Questions https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-text-expression-returns-null-instead-of-0/m-p/383391#M634 <HTML><HEAD></HEAD><BODY><P>Hi Emilie,</P><P></P><P>We applied a patch tonight and I just tested this on my end and it returns a zero now. Can you try it on your end and let us know if it worked?</P><P></P><P>Thanks,</P><P><BR />David</P></BODY></HTML> Wed, 21 Oct 2020 04:46:23 GMT DavidMartinez 2020-10-21T04:46:23Z Dynamic Text Expression Returns Null Instead of 0 https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-text-expression-returns-null-instead-of-0/m-p/383390#M633 <HTML><HEAD></HEAD><BODY><P>Hey there!</P><P></P><P>I'm using the expression editor to populate a text widget. The expression is substrating two <STRONG>SUM({fieldname})</STRONG> values.</P><P></P><P><SPAN style="text-decoration: underline;">Expression:</SPAN></P><P><IMG class="j-img-floatstart image-1 jive-image" src="https://community.esri.com/legacyfs/online/511274_pastedImage_2.png" style="float: left;" /></P><P><STRONG>SUM({Cases}) - SUM({Total Cases})</STRONG></P><P></P><P></P><P></P><P></P><P></P><P><SPAN style="text-decoration: underline;">Issue:</SPAN></P><P>When the math calculates to 0 I get a null return meaning nothing displays in my text box. When the math returns 0, I would like to display 0 in the text box.</P><P></P><P>Am I missing something in the expression editor?</P></BODY></HTML> Mon, 19 Oct 2020 16:18:30 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-text-expression-returns-null-instead-of-0/m-p/383390#M633 EmilieRabeau 2020-10-19T16:18:30Z Re: Dynamic Text Expression Returns Null Instead of 0 https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-text-expression-returns-null-instead-of-0/m-p/383391#M634 <HTML><HEAD></HEAD><BODY><P>Hi Emilie,</P><P></P><P>We applied a patch tonight and I just tested this on my end and it returns a zero now. Can you try it on your end and let us know if it worked?</P><P></P><P>Thanks,</P><P><BR />David</P></BODY></HTML> Wed, 21 Oct 2020 04:46:23 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-text-expression-returns-null-instead-of-0/m-p/383391#M634 DavidMartinez 2020-10-21T04:46:23Z Re: Dynamic Text Expression Returns Null Instead of 0 https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-text-expression-returns-null-instead-of-0/m-p/383392#M635 <HTML><HEAD></HEAD><BODY><P>That's great David - it worked!</P><P></P><P>I checked the app this morning and it behaves as expected. I see a 0 instead of a null value.</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/511474_pastedImage_2.png" /></P><P></P><P>Thank you for the quick reply. I appreciate it.&nbsp;</P><P></P><P>Emilie&nbsp;</P></BODY></HTML> Wed, 21 Oct 2020 15:01:39 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-text-expression-returns-null-instead-of-0/m-p/383392#M635 EmilieRabeau 2020-10-21T15:01:39Z Re: Dynamic Text Expression Returns Null Instead of 0 https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-text-expression-returns-null-instead-of-0/m-p/1543020#M15121 <P>&nbsp;</P><P>&nbsp;</P> Fri, 27 Sep 2024 11:50:55 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-text-expression-returns-null-instead-of-0/m-p/1543020#M15121 money_eb 2024-09-27T11:50:55Z