Averages in Pivot Table

[#1]

I have a straight table (snippet attached) that shows integer values, which is what I want. For each column, I have Total Mode set to Average of Rows. I'd like this average to be limited to say 3 decimal places so that it displays without being masked (with #####). Alternately, I'd like the value to be visually clipped and not masked. Any ideas? Thanks.

[sunny_talwar]

Try this may be:

If(Dimensionality() = 0, Num(yourExpression, '#,##0.000'), Num(yourExpression, '#,##0'))

and set the format to Expression Default on Number's tab

[#3]

Thanks. I'll try it out. One modification I might make is to wrap the Dimensionality() function around the format string itself, so I don't have to copy my expression twice (it's long and unwieldy).

[sunny_talwar]

Ya, that definitely seems like a good idea to test out. Let us know what results you get, I would be very curious to know.

Thanks,

Sunny