Sum of calculated Currency column without Power Automate

Jim_Allen with a number column you can display the total of an item and have a currency symbol using the following JSON:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "font-weight": "bold",
    "background-color": "#fefbea"
  },
  "children": [
    {
      "elmType": "span",
      "txtContent": "£",
      "style": {
        "display": "inline-block",
        "padding-left": "6px"
      }
    },
    {
      "elmType": "span",
      "txtContent": "@currentField"
    }
  ]
}

But you can't use JSON to add the currency symbol to to the sum at the bottom of the column.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)