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.