---
title: round
url: https://nexyron.tech/docs/cypher/functions/numeric/round
description: Rounds a floating point value to the nearest whole value. It is documented separately because numeric transforms change ranking, thresholds, and buckets in ways planner tools must
---

# round

## Generic Description

Rounds a floating-point value to the nearest whole value. It is documented separately because numeric transforms change ranking, thresholds, and buckets in ways planner tools must not guess.

Simple example:

```cypher
RETURN round(2.6) AS value
```

## Consumer-Level Explanation

Use it for presentation-friendly scores after doing the real calculation at full precision. Prefer this function when the transformation is a deliberate part of the model or report, and name the derived value in a `WITH` stage when it will be reused.

## More Detailed Explanation

`round` is scalar math, so it is evaluated per row after graph patterns, procedure output, or map projections have produced values. Keep it close to the query when thresholds, ranking, and derived fields need to be auditable and reproducible.

## Advanced Example

This example applies `round` to a named score component after matching graph data, making the derived metric reviewable before ordering.

```cypher
MATCH (d:Document)
WITH d, cosine_similarity(vector(properties(d).embedding), vector([0.22, 0.18, 0.44])) AS similarity
RETURN d.title AS document,
       round(similarity * 100.0) AS similarity_percent
ORDER BY similarity_percent DESC
```

## Real Use Cases

-   distance-from-target scoring
-   numeric bucketing and normalization before `ORDER BY` or aggregation
-   making scoring formulas visible to query review and assistant tooling

## Real Limitations And Tradeoffs

-   invalid numeric inputs produce null-like results rather than a repaired value
-   math functions do not fix poor feature scaling; choose transformations intentionally
-   nondeterministic functions such as random sampling are not appropriate for persisted decisions