Analytics Extended Metadata (XMD) Developer Guide
jNewer Version Available
Format Measures
Formatting a Measure
In this example lens, the values in the Sales column don’t include decimals or currency symbols.
The field now has the label “Sales (USD)” and its values include a currency symbol and two decimal places.
Formatting a Derived Measure
The following SAQL query contains a derived measure that calculates the average revenue per employee. As shown, the values in this derived field aren’t formatted.
The field now has the label “Revenue Per Employee” and its values include a currency symbol and a grouping separator.
More Formatting Examples
Check out these examples that illustrate how to use symbols to format measures and derived measures.
| Goal | XMD |
|---|---|
|
Display 500000 as $500,000 (prefix with “$”) |
|
|
Display 500000 as $500,000 (prefix with “$”, include grouping separator) |
|
|
Display 500000 as $500,000.00 (prefix with “$”, include grouping separator, apply 2 decimal places) |
|
|
Display 500000 as –$500,000.00USD (prefix with “–$”, include grouping separator, apply 2 decimal places, suffix with “USD”) |
|
|
Display Canadian currency code as a suffix (include grouping separator, apply 2 decimal places, suffix with “CAD”) |
|
|
Display -1,234.56 as –$1,234.56 (use a semi-colon delimiter for negatives, pos;neg) |
|
|
Display -1,234.56 as ($1,234.56) (Optional. Use a semi-colon delimiter, parenthesis for negatives, pos;(neg) |
|
|
Display -1,234.56 as $1,234.56- (Optional. Use a semi-colon delimiter, ‘-’ after the second delimiter, pos;neg;zero) |
|
For more information about using symbols in the customFormat field, see Measures and Derived Measures in XMD.