Ole Dyring
Articles
-
If-then-else
The demo will demonstrate a very common situation: A cross table that includes a custom calculation where a division-by-zero situation can occur. Labels can be added to the formula to enhance the r...
-
Count
Count counts all the values in a set of cells, while allcount counts all the cells regardless of content (null-values as well). This can be used to validate if all the wanted/required registrations...
-
The 4th parameter
The 4th parameter can be used to address problems concerning references out of range. References to cells not available in the current dataset (e.g. a reference to previous month in the first month...
-
Labels
With labels you can name specific expressions within your formula and refer to those labels from other places in the formula. This is especially useful when working with complex formulas, like the ...
-
If-then-else statements
If-then-else statements are used to check for certain conditions and to provide alternative results based on the different conditions. Specifically the if-then-else statement is useful to prevent a...
-
Calculation combined with visibility
Here we will work with calculations as a new measure and referencing a certain dimension value. Create a new Cost analysis with a crosstab showing Costs and No of Sales per Salesperson and by Prod...
-
Calculations in graphs
Let’ s look into how to use reference ranges and relative references. Add a Column chart to the Profit Analysis, Profit per Time YMD (on month level). Add the following calculations to the Column ...
-
Calculations in crosstabs
If we create at a crosstab based on Profit per Customer Country (attribute) and by Time Year (from the Sales cube), we should end up with a crosstab with 14 rows and 4 columns (not counting the Tot...
-
Reference ranges
E.g. d1:d-3 or m1:m3 – use two references separated by a colon to define a range of columns, rows or measures. Reference ranges can of course also be relative, e.g. -2:0 meaning a range starting 2...
-
Measure references
E.g. m1, m2, m3 etc. – referring to the first, second, third etc. of the inserted measures. 0 referring to the current measure (e.g. calculating a total on different measures)