text format in dimenesion

[Anonymous]

hi,

i have dimenesion feild in pivot  like this : 2.415687651321

what i need to write in the text format ?

i wrote like this but nathing happened.

=num(([filed]),'#,##0')

thanks,

yarin.

[nagaiank]

You may try using a calculated dimension with an expression like

Round(Num([field])

[Anonymous]

thank's

but still nathing heppened.

i need that feild will be 2.41.

thanks'

[#4 · Accepted solution]

can you try this?

=num([Field Name],'#0.00')