Treatment of zero value summary fields
I have as straightforward report which is based on the following data set up:
ValueField = Number
sValue = Summary(ValueField)
99% of the time there's a value in ValueField which is fine. The use case is that where there is no value, we should see a "-" instead of a blank, which is logically what the summary calculation is doing.
How can I get FM to show dashes on summary fields?
I've tried to alter the valuefield to something like: if(IsEmpty);"-";ValueField in the hope that the "-" would filter through to the summary calc, but this didn't work unfortunately, so any help is appreciated.
I'd put layout text in front of the summary field with this text and specify a Hide Object When setting to hide the layout text when it is not zero.