Page History

Link To URL

Allows you to pass the value of the returned data into a URL link. Use the hashes ## to indicate to Yellowfin where you want the column value to be placed in the URL itself. For example: Formatting on a column of IP addresses and the URL typed in is:

Image Removed

This essentially means that every IP address will be placed into it i.e.:

Image Removed

Org Reference Code

Converts the text in the cell to the value of an internal lookup table. E.g. AU to Australia

See Organisation Reference Codes for more information.

Raw Formatter

Displayed the data as it would have been returned from the database - – no additional formatting applied.

Text

Displays as plain text

Email Address

Creates a hyperlink on the text that will open an email client and pre-populate the sent to address.

URL Hyperlink

Creates a hyperlink on the text and will open web page on click. Assumes the text is a legitimate URL.

Flag Formatter

If your data contains ISO country codes you can display these as flags of the world instead of text.

Date

Displays value as a date - – multiple date options exist.

Time

Displays value as a time field - – multiple date options exist.

Timestamp

Displayed full date and time value

Date Part Formatter

Allows you display part of the date, e.g. Month Name, rather than the full date.

Numeric

Displays value as a decimal - – allows you to set the decimal places to be used.

Percentage Bar

Converts a percentage value less than or equal to 100 into a bar.

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' ‘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.２００３年４月２ 日 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.

See Advanced Functions for more information.

Prefix

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.

Thousand Separator

Turns the defaulted thousand separator for your instance on or off. For example:
1000 to 1,000