Here is a list of available functions.
|
Function |
Description |
|
Sum |
Summarizes the values in the reference range. Example: sum(d-1, 0, m1) |
|
Count |
Counts the number of cells in the reference range, except cells with null (blank) values. Example: count(all, 0, m1) |
|
Allcount |
Counts the number of cells in the reference range, regardless of null or not-null values. Example: allcount(all, 0, m1) |
|
Max |
Returns the maximum value in the reference range. Example: max(all, 0, m1) |
|
Min |
Returns the minimum value in the reference range. Example: min(all, 0, m1) |
|
Stdev |
Returns standard deviation of values in the reference range. Example: stdev(d-1, all, m1) |
|
Avg |
Returns average for values in the reference range. Example: avg(d-1, all, m1) |
|
Median |
Returns the median for values in the reference range. Example: median(d-1, all, m1) |
|
Rankasc |
Returns the rank, ascending order, for values in the reference range. Example: rankasc(d-1, all, m1) |
|
Rankdesc |
Returns the rank, descending order, for values in the reference range. Example: rankdesc(d-1, all, m1) |
|
Percentile |
Returns the percentile threshold for values in the reference range. Example: percentile(d-1, all, m1, 0.25) |
|
Rowname |
Returns 1 (true) if dimension member on row matches string. Example: rowname("Germany") |
|
Colname |
Returns 1 (true) if dimension member on column matches string. Example: colname("JEANS") |
| Rowdatevalue
|
Returns an integer based on date dimension, inserted as rows. Example: rowdatevalue("Posting Date") |
| Coldatevalue |
Returns an integer based on date dimension, inserted as columns. Example: coldatevalue("Posting Date") |
| Rowdateisdefined |
Returns 1 (true) if referenced row member contains a valid date. Example: rowdateisdefined("Posting Date", -1) |
| Coldateisdefined |
Returns 1 (true) if referenced column member contains a valid date. Example: coldateisdefined("Posting Date", -1) |
| Rowdateisnull |
Returns 1 (true) if referenced row member is null. Example: rowdateisnull("Posting Date") |
| Coldateisnull |
Returns 1 (true) if referenced column member is null. Example: coldateisnull("Posting Date") |
| Today |
Returns integer value for today's date. Respects date set by dynamic date origin. Example: today() |
The general usage is:
Function(cell range columns, cell range rows, measure range)
'cell range' can be just a single value like d1 or a range like d1:d3 (1st to 3rd) or all.
'measure range' can be a single measure like m1 or a range of measures like m1:m2. (1st and 2nd) or all.
Comments
Please sign in to leave a comment.