请尝试以下提及d脚本，它将累加值舍入到小数点后两位。

 aggs：{
total ：{
sum：{
script：Math.round（doc ['practiceObj.practiceValue']。value * 100）/100.0
} 

} 
} 
 

I have documents in elastic search that looks like :

{
                "entityFk": 0,
                "entityCode": "ADM",
                "entityObj": {
                    "id": 0,
                    "code": "ADM",
                    "description": "ADM - FIRSTCOM"
                },
                "practiceFk": 54745,
                "practiceObj": {
                    "id": 54745,
                    "code": "33.04.01.32",
                    "description": "Artrotomia ou artroscopia com tratamento de lesões articulares circunscritas  ",
                    "practiceValue": 23.5
                }
            }
        }

I want to sum all "practiceValue" (not null) that has entityCode.description equals to "FIRST", so I made this query :

    {
    "size" : 0,
    "query" : {
        "bool" : {
            "must_not" : [
                {
                    "missing" : { "field" : "practiceObj.practiceValue" }
                }
             ],
             "must" : [
                {
                    "match" : { "entityObj.description" : "FIRST" }
                }
             ]
         }
    },
    "aggs" : {
        "total" : {  
            "sum" : { "field" : "practiceObj.practiceValue"} 

        }
    }
}

Here is the result I obtained :

   {
    "took": 26,
    "timed_out": false,
    "_shards": {
        "total": 5,
        "successful": 5,
        "failed": 0
    },
    "hits": {
        "total": 11477,
        "max_score": 0,
        "hits": []
    },
    "aggregations": {
        "total": {
            "value": 1593598.7499999984
        }
    }
}

The deal is: how can i round up the value to 2 decimal point. Can someone help? Thanks.

EDIT:

here´s my mapping :

 {
    "index_practice_entities": {
        "mappings": {
            "practice_entities_search": {
                "properties": {
                    "entityCode": {
                        "type": "string"
                    },
                    "entityFk": {
                        "type": "long"
                    },
                    "entityObj": {
                        "properties": {
                            "code": {
                                "type": "string"
                            },
                            "description": {
                                "type": "string"
                            },
                            "id": {
                                "type": "long"
                            }
                        }
                    },
                    "practiceFk": {
                        "type": "long"
                    },
                    "practiceObj": {
                        "properties": {
                            "code": {
                                "type": "string"
                            },
                            "description": {
                                "type": "string"
                            },
                            "id": {
                                "type": "long"
                            },
                            "practiceValue": {
                                "type": "double"
                            }
                        }
                    }
                }
            }
        }
    }
}

Please try the below mentioned script, It will round the aggregated value to 2 decimal places.

"aggs" : {
        "total" : {  
            "sum" : { 
              "script" : "Math.round(doc['practiceObj.practiceValue'].value*100)/100.0"
               } 

        }
    }