The values selected in the Function column apply a specific format to a column in the search results. Options include the following:
- ROUND, ROUND TO HUNDREDTHS, and ROUND TO TENTHS will round a calculation so that results are easier to read than 0.2342456789943329. It applies to a numerical field—currency fields will round the amount by default.
- YEAR, QUARTER, MONTH, and so on returns the year, quarter, or month of a particular date, for instance, Sales by Quarter by Customer.
- WEEK OF THE YEAR converts the date in that row to the appropriate week of that year.
- AGE in DAYS/MONTHS/YEARS is used to calculate the time that has passed since a specific date.
- % of Total provides an additional metric to a SUM, a percentage of the ...