Formatting numbered Dimensions

[#1]

Hi, I am using a straight table, and while I have the ability to formate expressions, I dont have the ability to format dimensions. At least, I dont see a way. And I have a caclulated dimension where I want the end result to be set to 4 decimal places. So 0.0000. Is there a way to do this in the editor? Maybe wrap around some format setting around my formula?

Thanks

[lft · Accepted solution]

Hi David,

when working with calculated dimensions you will need to enclose your expression with Num

For instance : Num(Sum(Revenue), '#.##0,0000', '.', ',')

the last two parameters are decimal sep and thousand sep.

you absolutely need those when there is a difference between the ones in your format string, and the ones defined at the beginning of your script.

Loic

[#3]

Many thanks!