Value shown by the change function

Hello guys,

I just find this little problem in the watchlist. In fact, when i try to use the change() function to get the return over last 1,2,5 etc years, the value shown in the watchlist could either be the value without “%” sign or %% value as shown in the picture.

So can we have an option to get the value of change() as the value of ROC or how can we try to put them in the same way ?

Thank you for you time and have a good day ~~
1

I just found the instruction in the knowledge base

NOTE: divide the formula by 100 to display the results as a % in a watchlist by changing the Column Type to Percentage.

here is the link if anyone else interested

https://help.optuma.com/kb/faq.php?id=1185

bye~~