Fix Notion Formula Cannot Sum Currency: Mixed Symbol Workaround

When you create a Notion database to track expenses or sales, you often add a Currency property. But if you try to sum that currency column with a formula, the result displays as “0” or an error. This happens because Notion formulas cannot directly aggregate a Currency property. The root cause is that the Currency property type stores its value as a formatted string with a symbol, not as a plain number. This article explains why this limitation exists and provides a reliable workaround using a Number property to let your formula sum values correctly.

Why Notion Cannot Sum a Currency Property Directly

Notion offers several property types for numbers: Number, Currency, Percent, and Rollup. Each type stores data differently. The Currency property stores the value as a formatted string that includes a currency symbol such as $, €, or £. When you try to apply an aggregate function like sum() inside a formula, Notion’s formula engine expects a numeric input. Because the Currency property contains a non-numeric character, the function fails or returns zero.

The same limitation applies to other formatted number types like Percent. The Currency property is designed for display, not for mathematical operations inside formulas. Notion’s formula language does not include a built-in function to strip the symbol and convert the string back to a number. Therefore, you must store the raw numeric value separately.

This design is intentional. It keeps the Currency property simple for manual entry and visual clarity. But it creates a gap when you need to compute totals, averages, or other aggregations. The workaround uses a helper Number property that mirrors the Currency value as a plain number. The formula then sums the Number property instead.

Steps to Create the Helper Number Property and the Sum Formula

Follow these steps to add a Number column, copy values from the Currency column, and write a formula that sums the numbers correctly.

1. Open your database and add a Number property
   Go to the database where the Currency property exists. Click the + button in the last column header. Select Number from the property type list. Name this column “Helper Number” or any label that reminds you it is for formulas.
2. Enter numeric values in the Helper Number column
   For each row, type the same numeric value that appears in the Currency column. Do not include a symbol or comma. For example, if the Currency column shows $25.50, type 25.5 in the Helper Number column. If you have many rows, copy and paste the Currency values into a text editor, remove the symbols, then paste the plain numbers into the Helper Number column.
3. Create a formula property for the sum
   Click the + button in the last column header again. Select Formula from the list. Name this column “Total” or “Sum Helper”.
4. Write the sum formula
   Click inside the formula field of the new column. Type the following formula exactly:
   prop("Helper Number").sum()
   Replace “Helper Number” with the exact name of your helper column. Press Enter or click outside the field to save. The formula now displays the sum of all values in the Helper Number column.
5. Hide the Helper Number column (optional)
   To keep your database view clean, click the down arrow next to the Helper Number column header. Choose Hide from the menu. The column disappears from the current view but remains available for the formula.

The formula property updates automatically when you change a value in the Helper Number column. If you add a new row, enter the value in both the Currency column and the Helper Number column.

If Notion Still Shows Zero or an Error After the Workaround

Formula returns 0 even though Helper Number has values

Check the formula syntax. The most common mistake is using the wrong property name. Open the formula editor and verify that the name inside prop("") matches the helper column name exactly. Notion property names are case-sensitive. If the helper column is named “Helper Number” but you wrote “helper number”, the formula returns 0.

Helper Number column contains text instead of numbers

If you copy-pasted values that still contain a symbol or a comma, Notion treats the cell as text. The sum formula ignores text entries. To fix this, delete all values in the Helper Number column and re-enter them as plain numbers without any formatting. Use a period for decimals, not a comma.

Currency column uses a different decimal separator

Notion’s Currency property respects your locale settings. If your locale uses a comma as a decimal separator (e.g., 25,50), you must still enter the value in the Helper Number column with a period (25.5). Notion formulas only recognize the period as a decimal point.

Rollup formula also fails to sum Currency

The same limitation applies to Rollup properties. A Rollup that tries to sum a Currency column from a related database returns 0. Use the same workaround: create a Number property in the source database, then roll up that Number property instead.

Notion Number vs Currency Property: Key Differences

Item	Number Property	Currency Property
Data type stored	Plain number	Formatted string with symbol
Can be summed in a formula	Yes, with .sum()	No, returns 0
Accepts decimal values	Yes, with period separator	Yes, respects locale
Supports negative numbers	Yes	Yes, displays with minus sign
Shows a symbol ($, €, £)	No	Yes, configured in property settings
Works with Rollup aggregation	Yes	No, returns 0

This table shows that the Number property is the correct choice when you need to perform calculations. Use the Currency property only for display and manual entry.

You can now sum currency values in Notion by using a helper Number property. Set up the Helper Number column, enter plain numbers, and write a formula with .sum(). Hide the helper column to keep your view tidy. For advanced use, try adding a second formula that formats the total with a currency symbol using the format() function: "$" + format(prop("Helper Number").sum()). This gives you a readable total while keeping the underlying calculation correct.