Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Many thanks!