June 11, 201510 yr Hi - I have several fields that I want to show zero if the value is zero (rather than be blank). Some are calculated fields and some are user editable. On the data tab of the inspector, I have left UNCHECKED the option Do not display number if zero. Yet, they remain blank if zero. The fields are formatted as currency with fixed decimal set to 2. Is there some simple option I'm missing?
June 11, 201510 yr Zero and "blank" are different things. The field formatting checkbox displays the number even if it's zero. That's different than "displaying zero if the value is blank". Your fields need to contain the number zero if you want zero to be displayed. Change your calculations so they return zero. Give your number fields a default value of zero.
Create an account or sign in to comment