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.
Anchor
showfield
showfield
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.