Summary question marks? - can i get rid of them

[rivet]

It seems that if there is not data to summarize in a report I get question marks. How can I suppress those question marks?

[Ugo DI LUCA]

Hi,

Not sure I got it perfectly, but try using Sliding functions.

[Kurt Knippel]

Find out why those question marks are showing up and fix the problem. It could be as simple as field formatting.

[Vaughan]

I'd say the field is too small to display the number. Make it wider.

[kyle]

i agree with vauhgan. that will be it.

regards,

kyle

[Tamarin2087]

Rivet,

I get the same problem in some of my screens. In my case it is caused by a math error from my data. Basically, whenever I have data for one half of the calculation but none for the other I get the question mark because it is a divide by zero error. (i.e. a phone analyst has logged in, but taken no calls. So Average Time per call yeilds a question mark). I suppose you could place some validation logic in the field such as if RESULT<0, "".

Hope this helps.

[danjacoby]

The problem is that Summary fields can't return the result of a calculation.

I dunno, Rivet. I created a test file with a Summary field that (in this case) returns a zero, and I saw the "0" in the field. Didn't matter whether the field was in the body or a sub-summary part.

Which version of FMP are you using?

[rivet]

It is a divide by zero error. Here is the three fields I have:

stMale--Calc--Gender='Male' and DateBirth>0

stAgeM--calc--stMale*Age

stAvgM--summary--average of stAgeM weighted by _stMale

So if there is no data for the reported group I get a zero. Can anyone see a fix?

(I have attached a snap of the report created in FMP6)

[BobWeaver]

Try displaying a calculated field based on the summary field like this:

Case(IsEmpty(GetSummary(AverageFemaleAge, theBreakField)), "N/A",

GetSummary(AverageFemaleAge, theBreakField))