Enter or update the description of a calculated field to allow report writers to understand its purpose. This description will appear in a tooltip when hovered over calculated field columns.
Sub Format
Depending on the format option you have chosen for the column above you will have a separate set of sub format options. Select the appropriate sub format option.
Date Other
If you select ‘Other’ from the date sub format you will be able to build your own custom date format. For example to create a Japanese date format which includes characters, eg. 2003?4?2?would be created by adding in: yyyy?M?d ?
Decimal Places
If you have a defined a numeric format you can set the number of decimal places to be defined. This can be used to define cents in a decimal place for $20.00 by adding in:2 Note: To convert numeric data by doing divide by 1,000 calculations etc you would use the data conversion options in advanced functions which are available on the Report Fields page.
The prefix is used to include additional characters before the value that is returned from the data base. This can be used to define currency for $20.00 by adding in: $
Suffix
The suffix is used to include additional characters after the value that is returned from the data base. This can be used to define percentage for 30% by adding in: %
Rounding
The rounding format allows you to choose how a decimal value should be rounded.
Round Up: Will round any decimal up eg. 1.1 to 2
Round Down: Will round any decimal down eg. 1.9 to 1
Round Half Up: Rounds 0.5 and above up
Round Half Down: Rounds 0.5 and below down
Thousand Separator
Turns the defaulted thousand separator for your instance on or off. For example: 1000 to 1,000
Bracket Negatives
Displays negative values with or without brackets.
Show Field
To hide the column from the report, select this item. By hiding a column the data presented on the page is not re-grouped which would occur if you removed the field from your report. For Example:
Panel
borderColor
white
bgColor
white
title
Original Report
City
Country
Sum Revenue
London
UK
500,000
Manchester
UK
300,000
Hamburg
Germany
400,000
Munich
Germany
450,000
Panel
borderColor
white
bgColor
white
title
City Column Hidden
Country
Sum
Revenue
UK
500,000
UK
300,000
Germany
400,000
Germany
450,000
Panel
borderColor
white
bgColor
white
title
City Column Removed From Report
Country
Sum Revenue
UK
800,000
Germany
850,000
Suppress Duplicates
The suppression of duplicate option will remove duplicate values from a column and group the values under a single value.
...
Expand
title
Summary
Option
Description
Total Aggregation
Define the aggregation to be applied to the column as a total. Note: the calculated total is only available for calculated fields and will create a total based on the same rules as were used for the calculation. For example if you have a ratio of Received / Invoiced the total will equal the Sum (Received) / Sum (Invoiced)
Display Total Value
Show or hide the total aggregated value of a column. Note that this does not affect subtotals, i.e. if you’ve chosen to hide the total, the subtotals will still be displayed. Works for regular and cross-tab reports.
Move Total Value Location
When Display Total Value is activated, choose whether to display the table totals at their default location of the end of the table, or activate this option to move the totals to the start of the table.
Display Labels
Display a text label for the column summary.
Style
Define custom formatting for the summaries of this column. This covers the font facetypeface, font size, font colour and emphasis, font style, and text alignment.
Background
Define the background colour for the column summary.
Sub Total
Display a sub total row for each unique value in the column.
Move Sub Total Value Location
When Sub Total is activated, choose whether to display the table subtotals at their default location of the end of each section, or activate this option to move the subtotals to the start of each section.
Hide Sub Total on Columns
Select column fields from this list to hide their subtotal. Works for regular and cross-tab reports.
Tip: Remember to disable conditional formatting on subtotal cells if you’re opting to hide the subtotal values.