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

Hi,

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

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

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

i agree with vauhgan. that will be it.

regards,

kyle

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.

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?

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)

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

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

GetSummary(AverageFemaleAge, theBreakField))