Niels Thomsen
Articles
-
Difference percentage between first column and second column (as a column)
Type: Inserted as a columnDescription: Calculates the difference, as a percentage, between two values, first column and second column.Range:Columns: First column minus Second columnRows: Each rowMe...
-
Difference percentage between last column and second last column (as a column)
Type: Inserted as a columnDescription: Calculates the difference, as a percentage, between two values, last column and second last column.Range:Columns: Last column minus Second last columnRows: Ea...
-
Difference percentage between current row and previous row (as a measure)
Type: Inserted as a measureDescription: Calculates the difference, as a percentage, between two values, current row and previous row.Range:Columns: Each columnRows: Current row minus Previous rowMe...
-
Percentage (as a measure)
Type: Inserted as a measureDescription: Calculates each row value as a percentage of the total of all row values, in each column.Range:Columns: Each columnRows: Each rowMeasures: First measureSynta...
-
Percentage (as a column)
Type: Inserted as a columnDescription: Calculates each row value as a percentage of the total of all row values.Range:Columns: Last columnRows: Each rowMeasures: First measureSyntax:if sum(d-1, 0, ...
-
Minimum value (as a column)
Type: Inserted as a columnDescription: For each row, returns the minimum value among all column values.Range:Columns: All columnsRows: Each rowMeasures: First measureSyntax:min(all, 0, m1)Sample cr...
-
Standard deviation (as a measure)
Type: Inserted as a measureDescription: Calculates the standard deviation of all values in the range.Range:Each columnAll rowsFirst measureSyntax:stdev(0, all, m1)Sample crosstab: ExampleAdding Std...
-
Minimum value (as a measure)
Type: Inserted as a measureDescription: For each column, returns the minimum value among all row values.Range:Columns: Each columnRows: All rowsMeasures: First measureSyntax:min(0, all, m1)Sample c...
-
Maximum value (as a measure)
Type: Inserted as a measureDescription: For each column, returns the maximum value among all row values.Range:Columns: Each columnRows: All rowsMeasures: First measureSyntax:max(0, all, m1)Sample c...
-
Standard deviation (as a row)
Type: Inserted as a rowDescription: Calculates the standard deviation of all values in the range.Range:Each columnAll rowsEach measureSyntax:stdev(0, all, 0)Sample crosstab: ExampleAdding Stdev val...