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

    Treatment of zero value summary fields

    Stu412

      Title

      Treatment of zero value summary fields

      Post

      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.

       

      Thanks