Formatting a Calculated Dimension

[#1]

Hi,

Does anyone know how i can format a calculated dimension? I am trying to limit the number of decimal places displayed on my graph for the calculated dimension but the number format tab in my chart properties seem sto only apply to the expression in the chart.

Thanks!

[#2 · Accepted solution]

You can use Num(your calculated dimension,'###,###.##') with however many decimal places you want.

[MayilVahanan]

HI

You can able to apply num() function in calculated dimension.

Ex:

Num(Sales,'####.#0')

[#4]

Hi

You can apply as below:

=aggr(sum(num(Your value,'#,###.##')),Your value)

Thanks

[cleite2014]

I have two functions as below that will not format to numbers when exported to excel.  Is there another method to get all numeric values to import as a number in excel?  I am using Excel 2010.

Any ideas?

=round(aggr(sum(num(Hours,'###,###')), Owner)

=round(aggr(sum(num(Hours,'###,###')), Project, Owner)

Thank you,