Ole Dyring
Articles
-
References by name
[Cloud release: 2026.03.18][On-prem release: 2026 June][On-prem build: 26.05.22002]With this release the calculation interface has been improved on several points when you create a custom calculati...
-
Maximize object definition window
[Cloud release: 2026.02.05][On-prem release: 2026 March][On-prem build: 26.03.10001]When defining objects with many measures (20+ measures), it can become difficult to rearrange these measures with...
-
Scheduled jobs - open associated document
[Cloud release: 2026.03.04][On-prem release: 2026 March][On-prem build: 26.03.10001] Open a scheduled job from the scheduled jobs' list to see all the job properties.In the Source property, below t...
-
ROUND, Round value (as a measure)
Type: Inserted as a measureDescription: Rounds a value to nearest specified number of decimals.Range:Columns: Each columnRows: Each rowMeasures: First measureSyntax:round(sum(0, 0, m1); 0)Parameter...
-
ROUND, Round value (as a column)
Type: Inserted as a columnDescription: Rounds a value to nearest specified number of decimals.Range:Columns: Last columnRows: Each rowMeasures: First measureSyntax:round(sum(d-1, 0, m1); 0)Paramete...
-
MOD, remainder from division (as a column)
Type: Inserted as a columnDescription: Returns only the remainder from a division.Range:Columns: Last columnRows: Each rowMeasures: First measureSyntax:mod(sum(d-1, 0, m1); 3)Parameter examples:mod...
-
MOD, remainder from division (as a measure)
Type: Inserted as a measureDescription: Returns only the remainder from a division.Range:Columns: Each columnRows: Each rowMeasures: First measureSyntax:mod(sum(0, 0, m1); 3)Parameter examples:mod(...
-
INT, Integer value (as a measure)
Type: Inserted as a measureDescription: Returns the integer value lower of a number.Range:Columns: Each columnRows: Each rowMeasures: First measureSyntax:int(sum(0, 0, m1))Sample crosstab: ExampleI...
-
INT, Integer value (as a column)
Type: Inserted as a columnDescription: Returns the integer value of a number.Range:Columns: Last columnRows: Each rowMeasures: First measureSyntax:int(sum(d-1, 0, m1))Sample crosstab: ExampleIn the...
-
FLOOR, Floor value (as a measure)
Type: Inserted as a measureDescription: Returns the nearest integer value lower than or equal to a number.Range:Columns: Each columnRows: Each rowMeasures: First measureSyntax:floor(sum(0, 0, m1))S...