Hi Guys, I have a Script that counts (ACC()) the number of Pivots that occur over a period and then displays the result using a CHART ELEMENT. The result from my Script is always an integer value, however it is displayed as a decimal value with the number of decimal places the same as that shown on the Chart Y-axis. Integers displayed to 3 or more decimal places just don’t look right. Is there a way I can format the result from my Script as an integer, or other user specified format? Cheers Trevor
In the Chart Element tools properties change the Field Type from Auto to Number. When you do a new property will display called Price Display Format which you can use to set the value to use zero decimal places.
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.