Data format on a Dimension field

[#1]

We have a field on an SQL table that has a value of 0.0293. When I use this field in a pivot table as a dimension field it shows 0.03. How do I get it to show 0.0293?

Thanks,

LMAS

[mike_garcia]

Maybe with a calculated dimension using the num function...

[Miguel_Angel_Baeyens · Accepted solution]

As pointed out by Mike, use

Num(YourField, '#,000')

Quoted text is the format of the field. Hope this helps

[#4]

Thanks, for the quick response. That did give me what I was looking for.

LMAS