1 of 1 people found this helpful
There are a number of ways to do that depending on the calculation.
Here's one method:
//put calculation you already have here + 0
And make sure that the "do not evaluate if all referenced fields are empty" option is cleared.
Hey Phil thanks....Great that worked on the calculated field. I should of also mention what if its just a number field?
With simple number fields, I'd set them up to auto-enter a 0.
Yep thats just what I was guessing.
What if it's a summary field? There are no auto-enter options for summary fields and no calculations to edit. All you can do is select the summary type.
It would be nice if you could do this in the summary field options or in the data formatting section of the inspector. If you select decimal format you can tell a field not to display if the value is zero, but you can't tell it to display a zero if the value is empty.
You can define a calculation field that references the summary field. Context is important here and that might also require use of the GetSummary function for subtotals like you get in sub summary parts.
You could also put a plain layout text such as 0.00 or whatever you need right on top of the summary field and use Hide Object When to hide the text unless the summary field is empty.