CHART ELEMENT Display Format

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?




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.


Thanks Matthew,

I figured the function had to be there somewhere but just could see the flowers in the forest.