Rounding a summary field

[enquirerfm]

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.

[Cabinetman]

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

[bcooney]

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, 2010 by Guest

[RodSierra]

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.

[enquirerfm]

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.

[comment]

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?

[charisse]

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.

[Steve Martino]

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