Dynamic Text Expression Returns Null Instead of 0

[EmilieRabeau]

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?

[DavidMartinez · Accepted solution]

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]

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