Thursday, March 22, 2012

Can't seem to round an average.

I am using an expression to create an average. The result is an odd number like 33.666666666666667.

I want to round this to 34 (I would even accept 33, or 33.67), just not so manny digits to the right.

Hello Patrick,

Try this in your expression:

=Round(Avg(Fields!Number.Value), 2)

The 2 in my example is how many digits to include.

Hope this helps.

Jarret

sql

No comments:

Post a Comment