Percentage in scripted fields

[Pranusha119 (Pranusha)]

Hi

I have divided two fields using below script

return doc['StatusOpen'].value/doc['StatusSent'].value

for this result should be 2/31 = 0.06451 = 6.451% but it's giving 0 %

As I have format as percentage and Numeral.js format pattern as 0,0.[000]%

May I know where I went wrong.

[flash1293 (Joe Reuter)]

StatusOpen and StatusSent are probably of type int - in this case the / operator is doing an integer division. By casting them to double it should work as expected (https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-casting.html ):
return ((double) doc['StatusOpen'].value)/((double) doc['StatusSent'].value)

[Pranusha119 (Pranusha)]

Awesome!! it's working @flash1293