[Solved] Text in repeating group is showing blank instead of zero

When my repeating group text returns a result from the sum of a field that is zero the text instead shows blank.


Can I put a condition on the text to show $0.00 instead of being blank


Yep, you can do exactly that. “When Current User’s Currency Search for Expenses’s Amount:sum:formatted as 1028.58 is 0”

Set text to be $0.00


Thanks so much @andrewgassen. Could not get this to work using “is 0” but did use “is empty” and all is good. Thank you

1 Like