AnsweredAssumed Answered

Treatment of zero value summary fields

Question asked by Stu412 on Jun 16, 2015
Latest reply on Jun 16, 2015 by philmodjunk


Treatment of zero value summary fields


Hi there

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.