date
, then a drop-down list appears and enables you to select any of the operators and data items whose names
begin with “date.”
'Year'n
to
avoid conflict with the Year operator.
[raw]
(to use unformatted values) or [formatted]
(to use formatted values) to the right of the data item.
'Expenses'n[formatted]specifies that the Expenses measure is evaluated as a formatted value.
"O'Reilly"
, 'O\'Reilly'
,
and '"Hello"'
are all
valid.
\r
, \n
,
or both to specify the newline character.
Date
|
'23JUN2013'd
'JUN2013'd
'2013'd
'q32013'd
|
Datetime
|
'23JUN2013_5:23:55’dt
'23JUN2013_5:23'dt
'23JUN2013'dt
|
Time
|
'_12:23:55't
'_12:23't
|
Elapsed Time
|
'44:23:55't
'00:01:34't
|
sum [bygroup] ('cost'n)aggregates the sum of the measure COST for each BY-group value.