Formula from fields

[peretz_shlomi]

Hi

I need a new column with formula 'NG Amount' / 'Component Qty' * 1000000

I tried to perform SCRIPTED FIELDS but without success.

Thanks for the helpers

[flash1293 (Joe Reuter)]

Can you share what you tried with scripted fields?

[peretz_shlomi]

I tried very simply
doc[‘component qty].value / doc[‘NG amount’].value

[peretz_shlomi]

Anyone please?

[balaji_18 (balaji)]

Hi, can you please try https://github.com/fbaligand/kibana-enhanced-table, this plugin do mathematical caculations

[flash1293 (Joe Reuter)]

Sorry for the delay. It seems like there are documents in your index that do not contain the fields you are working with here.

You can check with

if (doc['my-field-anme'].value != null)

and return a default value if it's not available.

[peretz_shlomi]

hii
It gave me a result, but really wrong

I will try to explain what I want to do maybe there is another way.
I'm trying to do a division and multiplication operation for the formula.

(B / A) * 1000000

[Ankita_Pachauri]

Try using tsvb.