CHART ELEMENT Display Format

Optuma Scripting
1

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

2

Hi,

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.

Ex7

3

Thanks Matthew,

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

Cheers

Trevor