BIFROST.LEDGER
Runs one of your organisation's formulas and returns its aggregated value — a single number in a single cell.
Syntax
=BIFROST.LEDGER(formulaName, [param1], [param2], …)| Argument | Required | Description |
|---|---|---|
formulaName | Yes | The name of a formula defined for your organisation, in quotes. This is what decides which data is read. |
param1 … param14 | Depends | Values for that formula's parameters, in the order the formula defines them. Which ones are required is part of the formula, not of the function. |
Examples
These use the default formulas, which take an account, a year and a month in that order. Yours are listed under Formulas in the portal, with their parameters.
=BIFROST.LEDGER("BALANCE", "1000", "2026", "1")
=BIFROST.LEDGER("NETCHANGE", "3000:3999", "2026", "1")
=BIFROST.LEDGER("NETCHANGE", "3***", "2026", "1")Account arguments
Where a formula takes an account, it accepts more than a single code:
"4000"— one account"4000:4999"— an inclusive range"4*"— a wildcard, where*stands for one character. So4*matches 40–49, not 4000–4999. For four-digit accounts use4***or a range.
The exact separators can be configured for your organisation under Formulas → Syntax, so yours may differ from the examples above.
Leaving out a required parameter
The cell returns an error naming what is missing, and nothing is read from your ERP. That is deliberate: an omitted parameter is a dropped filter rather than a narrower question, so the number that came back would be wrong rather than empty.
Checking a value
BIFROST.ENTRIES takes the same formula name and the same arguments and returns the individual transactions instead of the total, so the rows always reconcile to the number.