How to format numbers in straight table?

[#1]

Hi,

I'm struggling to format numbers in a straight table - I have figures like "11,121412341" in several columns. There doesn't seem to be a way to format it.

Is there any way to get around it? If I switch to pivot table I only see my "expression" and I need to have all columns visible all time.

Would it make sense to round figures at a script level? That would probably impact the value of my calculations? Perhaps there is a way to trim the values somehow?

Best regards,

CaptainP

[#2 · Accepted solution]

Hi CaptainP

You can set formatting for dimensions in Document Preferences => Number

Lukasz

[jvishnuram]

Hi Captain,

your figures in expression or dimension, if it is in expression it should show in the number tab. or let me know if my understanding is wrong about your requirement. 

[Anonymous]

CaptainP

Have you tried using a Calculated Dimension, as in something like :

     =round( [YourField] )

Best Regards,     Bill

[johnca]

In a straight table formatting is controlled on the Numbers tab. Highlight the desired field and select Override Document settings, then depending on your requirements, select Fixed To and set the Decimal selector to 1 or 2 (or?). Another possibility is to use Integer, Number or Money selections.

HTH,

--john

[#6]

Łukasz,

works perfectly

Thanks

CaptainP