Rounding off numbers in charts

[#1]

Hi Everyone

How can I round off my dimension and expression numbers in a straight table?

I have figures like "2.3478854785646" and I just need this to be "2.4".

[Anonymous]

Assuming you always want to round up

     ceil(2.3478854785646,0.1)

Or for a normal rounding

     round(2.3478854785646,0.1)

[danieloberbilli]

Dimension tab - select the dimension - click on edit

Num(Field, '#.#')

[Anonymous]

Hi ,

Use Round() function in expression

Ex : Round(Sum(Sales))

[#5]

Thanks everyone. I have used a Round() function and it works.

Now my Total does not have commas e.g "3045862147". How can I make it to include commas to in between to distinguish thousands, hundreds...etc?

[Anonymous]

num ( 3045862147.3 , '#,##0.0')

[jonathandienst]

Be careful of using rounding. On large tables it will cause rounding differences in the totals. Better to use Num(...) as this formats it correctly without changing the data. Or better still, set the expression format in the Numbers tab of the chart properties

[vardhancse]

in chart properties->number<tab>, we can change the number format of expressions as required.

[#9]

Hi Jonathan

I want something like this but it doesnt work.

Num(Sum([Colour Cost],'#,##0.0'))

[CELAMBARASAN]

Specify format to Num expr not to Sum

Num(Sum([Colour Cost]),'#,##0.0')