Fix Notion Formula Decimal Precision Lost After Specific Operation

Notion formula results sometimes display fewer decimal places than expected. This happens when a formula performs arithmetic on numbers from different sources, such as a rollup and a manually typed number. The root cause is Notion’s internal handling of number types, which can round results to the least precise input. This article explains why decimal precision drops and provides step-by-step fixes to restore full decimal accuracy.

Why Notion Formula Loses Decimal Places

Notion stores numbers as floating-point values. When a formula combines values from different sources — for example, a rollup that returns 3.14 and a manual property that contains 2.0 — Notion may round the result to the least precise input. This is not a bug but a design choice to avoid displaying excessive decimal places in most cases. However, for users who rely on exact decimal values, this behavior causes precision loss.

The precision loss is most noticeable after operations like multiplication or division. For instance, a rollup that returns 10.50 multiplied by 1.2 may show 12.6 instead of 12.60. Notion truncates trailing zeros unless you force the format. Additionally, if you use the round() function with a fixed number of decimals, the result may still display fewer decimals if the formula’s input values have fewer decimal places.

Steps to Fix Decimal Precision in a Notion Formula

These steps apply to any Notion formula property that produces a number with fewer decimals than expected. You will edit the formula directly in the database property settings.

1. Open the database containing the formula
   Navigate to the Notion page where the database lives. Click the database name at the top of the view to open its properties panel.
2. Locate the formula property
   In the properties panel, find the formula property that shows the wrong decimal count. Click the property name to open the formula editor.
3. Wrap the existing formula with round()
   Place your cursor at the beginning of the formula. Type round( then add a comma and the number of decimals you want. For example, if your formula is prop("Price") prop("Quantity"), change it to round(prop("Price") prop("Quantity"), 2). Close the parentheses. This forces the result to exactly two decimal places.
4. Use format() to preserve trailing zeros as text
   If you need trailing zeros to always appear, wrap the round() result with the format() function. Example: format(round(prop("Price") prop("Quantity"), 2)). This converts the number to a text string, so 12.60 appears as “12.60” instead of “12.6”. Note that the property will become a text type, not a number type.
5. Check the rollup source for rounding
   If your formula uses a rollup, the rollup itself may already be rounding. Click the rollup property and change the Show Original setting to On. This displays the raw unrounded value from the source database. Then adjust the formula to use that raw value.

If Notion Still Shows Wrong Decimal Places After the Fix

Formula uses a rollup that is set to round

Open the rollup property in the properties panel. Under Rollup, change the Show Original toggle to On. This bypasses any rounding applied by the rollup. Then update the formula to reference the rollup property directly.

Formula uses a number property with limited decimals

Check the source number property. Click the property name and ensure the Number Format setting shows the correct decimal places. For example, set it to 2 decimal places. Then the formula will inherit that precision.

Formula result is a text string that looks like a number

If you used format() and the result still truncates, the source might already be a text value. Convert the source to a number property first. Then reapply the round() and format() functions.

Notion Formula Precision: Number vs Text Output Compared

Item	Number Output (no format)	Text Output (with format)
Result display	12.6	“12.60”
Trailing zeros	Dropped	Preserved
Usable in further formulas	Yes	No
Sort order	Numerical	Alphabetical

Use number output when you need to perform additional calculations. Use text output only for display purposes, such as in a table or board view where exact decimals matter.

You can now restore decimal precision in any Notion formula by applying the round() function with a fixed decimal count. For permanent trailing zeros, convert the result to text with format(). To avoid precision loss from rollups, enable Show Original on the rollup property. As an advanced tip, combine round() with prop() inside a single formula to maintain both precision and the ability to use the result in other formulas.