# Formula from fields

**URL:** <https://discuss.elastic.co/t/formula-from-fields/229570>\
**Category:** Kibana\
**Created:** [April 24, 2020, 4:27am UTC](https://discuss.elastic.co/t/formula-from-fields/229570 "2020-04-24T04:27:18Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![peretz\_shlomi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/peretz_shlomi/32/54701_2.png) [@peretz\_shlomi](https://discuss.elastic.co/u/peretz_shlomi)\
**Post date:** [April 24, 2020, 4:27am UTC](https://discuss.elastic.co/t/formula-from-fields/229570/1 "2020-04-24T04:27:19Z")

</div>

Hi

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

I tried to perform SCRIPTED FIELDS but without success.

 ![Annotation 2020-04-24 070503](https://us1.discourse-cdn.com/elastic/original/3X/c/a/ca2a77dd1858445248114b35c183380a9cd9c6b6.jpeg)

Thanks for the helpers

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [April 24, 2020, 9:08am UTC](https://discuss.elastic.co/t/formula-from-fields/229570/2 "2020-04-24T09:08:20Z")

</div>

Can you share what you tried with scripted fields?

---

<div class="post-metadata">

**Author:** ![peretz\_shlomi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/peretz_shlomi/32/54701_2.png) [@peretz\_shlomi](https://discuss.elastic.co/u/peretz_shlomi)\
**Post date:** [April 25, 2020, 3:51pm UTC](https://discuss.elastic.co/t/formula-from-fields/229570/3 "2020-04-25T15:51:40Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/b/5b39252ae080052914b99c3d4473f0592649aaa3.jpeg)

---

<div class="post-metadata">

**Author:** ![peretz\_shlomi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/peretz_shlomi/32/54701_2.png) [@peretz\_shlomi](https://discuss.elastic.co/u/peretz_shlomi)\
**Post date:** [April 30, 2020, 9:51am UTC](https://discuss.elastic.co/t/formula-from-fields/229570/4 "2020-04-30T09:51:27Z")

</div>

Anyone please?

---

<div class="post-metadata">

**Author:** ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)\
**Post date:** [April 30, 2020, 10:33am UTC](https://discuss.elastic.co/t/formula-from-fields/229570/5 "2020-04-30T10:33:12Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [April 30, 2020, 1:00pm UTC](https://discuss.elastic.co/t/formula-from-fields/229570/6 "2020-04-30T13:00:54Z")

</div>

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

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

```

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

---

<div class="post-metadata">

**Author:** ![peretz\_shlomi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/peretz_shlomi/32/54701_2.png) [@peretz\_shlomi](https://discuss.elastic.co/u/peretz_shlomi)\
**Post date:** [May 2, 2020, 4:24pm UTC](https://discuss.elastic.co/t/formula-from-fields/229570/7 "2020-05-02T16:24:58Z")

</div>

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

 ![samp](https://us1.discourse-cdn.com/elastic/original/3X/6/b/6bb26a545daf9e9e380d3f637809389533074f30.png)

---

<div class="post-metadata">

**Author:** ![Ankita\_Pachauri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ankita_pachauri/32/61469_2.png) [@Ankita\_Pachauri](https://discuss.elastic.co/u/Ankita_Pachauri)\
**Post date:** [May 3, 2020, 5:42pm UTC](https://discuss.elastic.co/t/formula-from-fields/229570/8 "2020-05-03T17:42:03Z")

</div>

Try using tsvb.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 31, 2020, 5:42pm UTC](https://discuss.elastic.co/t/formula-from-fields/229570/9 "2020-05-31T17:42:15Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.