# Doing Math over count of events

**URL:** <https://discuss.elastic.co/t/doing-math-over-count-of-events/97278>\
**Category:** Kibana\
**Created:** [August 16, 2017, 2:28pm UTC](https://discuss.elastic.co/t/doing-math-over-count-of-events/97278 "2017-08-16T14:28:23Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![shroh](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@shroh](https://discuss.elastic.co/u/shroh)\
**Post date:** [August 17, 2017, 2:46pm UTC](https://discuss.elastic.co/t/doing-math-over-count-of-events/97278/3 "2017-08-17T14:46:57Z")

</div>

> [@LeeDr](#):
>
> transactionStatus:Success

Thanks Lee for the nice explanation, but for me it doesnt work. In my case the TransationStatus field is text based and i want to calculate what was the percentage of Successful transaction out of total.

SuccessRate= Round(SUCCESS/(SUCCESS + FAILURE)\*100 , 2)

The method you mentioned doesnt work for me. It is always showing 0.

---

_[View the full topic](https://discuss.elastic.co/t/doing-math-over-count-of-events/97278)._