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

Need help Database
1

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

image

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

image

2

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

2 Likes
3

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