To display the available time functions, expand the Time group in Formula Type.
To display the time functions that can be applied to the Time dimension members, expand the Time (In Time) group.
.png)
|
Function |
Description |
Syntax |
|
YTD |
Returns Year-to-Date value for the selected member (from beginning of year to current date) |
YTD(Parameter1) |
|
QTD |
Returns Quarter-to-Date for the selected member (from beginning of quarter to date) |
QTD(Parameter1) |
|
MTD |
Returns Month-to-Date for the selected member |
MTD(Parameter1) |