Dynamic Text Expression Returns Null Instead of 0

513
2
Jump to solution
10-19-2020 09:18 AM
EmilieRabeau
Esri Contributor

Hey there!

I'm using the expression editor to populate a text widget. The expression is substrating two SUM({fieldname}) values.

Expression:

SUM({Cases}) - SUM({Total Cases})

Issue:

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.

Am I missing something in the expression editor?

0 Kudos
1 Solution

Accepted Solutions
DavidMartinez
Esri Regular Contributor

Hi Emilie,

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?

Thanks,


David

View solution in original post

2 Replies
DavidMartinez
Esri Regular Contributor

Hi Emilie,

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?

Thanks,


David

EmilieRabeau
Esri Contributor

That's great David - it worked!

I checked the app this morning and it behaves as expected. I see a 0 instead of a null value.

Thank you for the quick reply. I appreciate it. 

Emilie 

0 Kudos