1 Reply Latest reply on Jun 16, 2015 6:37 AM by philmodjunk

    Treatment of zero value summary fields



      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.