I have found a number in a summary field which calculates the average I require. How do I round this number up or down - I have the formula I need what I don't see is where I can do this e.g. it is not available when on defines the field or by setting the number format or in Replacing field contents.

Round up as in 14.5 to 14 ?? If so Number Format in layout view, format as decimal, fixed number, 0 places.....

Remember, summary fields calc based on a found set. Therefore, you must ensure that you have found all the records that should be in the report.

Number display is not a true Round.

How about using a self-join relationship (not found set dependent) and the Average ( ) and Round ( ) functions?

Edited May 11, 201015 yr by Guest

I would most likely round the original calculation that is being summarized, and then use the summary. Aggregates on large found sets can get quite slow, but also work.

Not sure if this is best but in the end I created a new field which simply used the Get(Summary) function. I then used this field as part of a calculation in another one where I applied the rounding formula. Seems to work fine. Thx for your help.

I created a new field which simply used the Get(Summary) function.

Why not eliminate the middleman and use Round ( GetSummary ( summaryField ; breakField ) ; precision ) directly in the calculation?

On 5/11/2010 at 1:39 PM, comment said:

Round ( GetSummary ( summaryField ; breakField ) ; precision )

I think that this would work well for me, but I am not clear as to what the "breakField" refers.

Break field is the field you are sorting on in your subsummary part