Source
Self-service analysis & shared metrics — found from sitemap — BOARD
Checked for BOARD on 17 Nov 2026
- Page
- https://help.board.com/docs/nexel-formula-editor
- Checked
- 17 Nov 2026, 11:26 UTC
- How we may use it
- Public page, crawling permitted
Technical details
- type
- page
- http status
- 200
- content hash
- sha256:ec796c033810bbfabf0daf68539a6e0f87c7c9a7fab38732f486f5e618477c24
- permission
- robots_ok
- screenshot
- Screenshot on file (internal exhibit, not published)
Cited by
Facts read from this source
-
Nexel description Report an error
“Nexel combines the flexibility and the versatility of a spreadsheet-like application with the power and robustness of a multidimensional object like the Data View. It offers a wide library of formulas embedded in the reporting layer to provide additional calculation capabilities on columns, ranges of cells and even single cells.”
-
Nexel formula supported blocks Report an error
“Formulas always start with an equal sign (=) and are supported by any Data Blocks containing one or more of: A Cube An Algorithm Entities & Relationships An Empty Block”
-
Nexel formula types Report an error
“Deepest entity formula (default). Each cell of the Block can have a different formula. Single formula. The formula is the same for all cells of the Block. A third option, Text Cube formula, is available when certain conditions are met.”
-
Nexel vertical layouts unsupported Report an error
“The Nexel feature is not supported on vertically-aligned Layouts.”
-
Nexel default operator Report an error
“If omitted, the SUM operator is applied by default.”
-
Nexel column naming Report an error
“In the Nexel spreadsheet, the first column is A, the second column B, and so on up to Z. Nexel then uses two letters: AA to AZ, BA to BZ, and so forth until ZZ.”
-
Nexel dynamic ranges Report an error
“Dynamic Ranges allow the selection of large sets of cells as function inputs and overcome limitations such as when Blocks have a different number of visible cells in the Data View.”
-
Nexel single block ranges Report an error
“Ranges can be defined only on a single Block. They can’t collect cells belonging to different Blocks.”
-
Nexel drill down Report an error
“Drilling down is allowed only for "Single formula" configurations: in those scenarios the Nexel level is also applied to the drilled report, but it can't be modified at that level.”
-
Nexel write in place Report an error
“You can save results of Nexel formulas into Cubes just like you would with Data Entry actions. To save Nexel results in a Cube, the following conditions must be met: Nexel formulas must be created on a Cube type Block. Data entry must be active on the Block. The "Allow write in place" flag must be checked in the Nexel Formula editor.”
-
Nexel action library Report an error
“You can save your current Nexel spreadsheet as an element of the Action Library. The Action Library is a group of actions specific to each Board Data Model.”
-
Nexel action transfer restriction Report an error
“Actions saved in the Action Library of a Data Model cannot be copied or transferred to another Data Model.”
-
Nexel writeback physical level Report an error
“A Nexel writeback action is able to write data only at the physical level of a Cube.”
-
Nexel relationships Report an error
“You can use Nexel to manage Relationships between two Entities based on the result of a Formula. This allows you to dynamically change Relationships between two Entities when certain conditions change.”
-
Nexel text cube formulas Report an error
“Text Cubes can be used to edit Nexel Formulas. This is particularly useful for creating prepackaged Formula schemas that can be easily reused in several Nexel sheets.”
-
Nexel crossview Report an error
“The Nexel CrossView feature allows you to collect data from multiple Data Views inside a Screen. It is a very advanced feature and it's particularly useful for summarizing data from several Data Views into one.”
-
Nexel crossview save prerequisite Report an error
“The Screen must be saved before using the CrossView feature.”
-
Nexel function library PDF Report an error
“The complete description of all supported functions is available in the Nexel Complete Function Library file (2.6 MB, PDF)”
-
Nexel add new block Report an error
“From the Formula editor, you can add a Block to the Layout on the fly: simply click on the "+ ADD NEW BLOCK" button in the top right corner of the page. The new Block is an algorithm Block with Nexel already enabled on it.”
-
Nexel selection constraint Report an error
“a formula cannot refer to cells that are outside of the current Selection.”
-
Nexel hidden cells counted Report an error
“You can use Filters to hide rows, but all hidden cells are still considered in the execution of the Formula.”
-
Nexel color alerts Report an error
“If a Color alert is set up on a Block where data and Nexel Formula calculations coexist, the results of the Nexel formulas will determine the behavior of the alert and not the underlying values.”
-
Nexel deprecated option Report an error
“The "Use configuration pages" option is currently deprecated but is still available for backward compatibility purposes.”
3 facts read from this page are not shown because they could not be confirmed on the page as captured.
Scores citing this record
- The Data Analyst Dashboards, charts & interactivity
- The Data Analyst Self-service analysis & shared metrics
- The Finance Controller Self-service analysis & shared metrics
- The IT Administrator Self-service analysis & shared metrics
- The Managing Director Dashboards, charts & interactivity
- The Managing Director Self-service analysis & shared metrics
- The SaaS Product Lead Dashboards, charts & interactivity
- The SaaS Product Lead Self-service analysis & shared metrics
- The Skeptic Dashboards, charts & interactivity
- The Skeptic Self-service analysis & shared metrics