# Need to remove the scientific notation on sum Aggregation

**URL:** <https://discuss.elastic.co/t/need-to-remove-the-scientific-notation-on-sum-aggregation/341193>\
**Category:** Elasticsearch\
**Tags:** kql-kibana-query-language\
**Created:** [August 21, 2023, 1:16am UTC](https://discuss.elastic.co/t/need-to-remove-the-scientific-notation-on-sum-aggregation/341193 "2023-08-21T01:16:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sakthi1](https://avatars.discourse-cdn.com/v4/letter/s/6a8cbe/32.png) [@Sakthi1](https://discuss.elastic.co/u/Sakthi1)\
**Post date:** [August 21, 2023, 1:16am UTC](https://discuss.elastic.co/t/need-to-remove-the-scientific-notation-on-sum-aggregation/341193/1 "2023-08-21T01:16:40Z")

</div>

My Index Mapping:

"total"{  
"type": :"double"  
"ignore\_malformaed": "true"  
}

when i perform sum on this field i am getting the scientific notation.

Query i triggered:

POST /\_sql {  
"query": "select sum(total) from "testindex"

}

Result i am getting is: 178264528827E8  
Result i Need is: 17826452882767927828

Can you guide me how i can remove the scientific notation on the result.

---

<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:** [September 18, 2023, 1:17am UTC](https://discuss.elastic.co/t/need-to-remove-the-scientific-notation-on-sum-aggregation/341193/2 "2023-09-18T01:17:00Z")

</div>

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