Option |
Description |
Display |
To change the display name of the column from=
the default value simply update this field. |
Format |
Each data type will have a unique set of form=
at options =E2=80=93 eg Text, Date or Numeric.
See Display Formats for=
details on each type.
|
Sub Format |
Depending on the format option you have chose=
n 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 =E2=80=98Other=E2=80=99 from th=
e 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 ? =
td>
|
Decimal Places |
If you have a defined a numeric format you ca=
n set the number of decimal places to be defined. This can be used to defin=
e 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 d=
ata conversion options in advanced functions which are available on the Rep=
ort Fields page.
See Advanced Functions for more information.
|
Prefix |
The prefix is used to include additional char=
acters before the value that is returned from the data bas=
e. This can be used to define currency for $20.00 by adding in: $=
strong> |
Suffix |
The suffix is used to include additional char=
acters 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=
li>
- 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 yo=
ur instance on or off. For example:
1000 to 1,000 |
Bracket Negatives |
Displays negative values with or without brac=
kets. |
Show Field |
To hide the column from the report, select th=
is item. By hiding a column the data presented on the page is not re-groupe=
d which would occur if you removed the field from your report. For Example:=
City |
Country |
Sum Revenue |
London |
UK |
500,000 |
Manchester |
UK |
300,000 |
Hamburg |
Germany |
400,000 |
Munich |
Germany |
450,000 |
Country |
Sum |
Revenue |
UK |
500,000 |
UK |
300,000 |
Germany |
400,000 |
Germany |
450,000 |
Country |
Sum Revenue |
UK |
800,000 |
Germany |
850,000 |
|
Suppress Duplicates |
The suppression of duplicate option will remo=
ve duplicate values from a column and group the values under a single value=
. |
Based on the type of field that the column being formatted is there are =
various format options. The ones listed below come default with Yellowfin, =
however as this is customisable there may be additional ones that comes as =
part of your installation.
Format Option |
Description |
Text |
Displays as plain text |
Case Formatter |
Allows you to format text as Uppercas=
e or Lowercase. |
Email |
Creates a hyperlink on the text that will ope=
n an email client and pre-populate the sent to address. |
Flag Formatter |
If your data contains ISO country codes you c=
an display these as flags of the world instead of text. |
HTML |
Formats a field containing HTML tags, either =
by removing them, or using them, depending on user selection. For example, =
if you wanted to display an image using a URL the field may look something =
like this:
<img src=3D"http://imagepathhere.png" /> .=
|
HTML 5 Video |
Displays a video from a path stored in the fi=
eld, either a full URL, or a relative path if the video is stored in the Ye=
llowfin ROOT directory. |
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 i=
s: http://www.google.com.au/search?hl=3Den&=
amp;q=3D##This essentially means that every ip address will be place=
d into it into it i.e.: http://ww=
w.google.com.au/search?hl=3Den&q=3D10.100.32.44 |
Org Ref Code |
Converts the text in the cell to the value of=
an internal lookup table. E.g. AU to Australia. See Org Ref Codes for more information.<=
/p> |
Raw Formatter |
Displayed the data as it would have been retu=
rned from the database =E2=80=93 no additional formatting applied. |
URL Hyperlink |
Creates a hyperlink on the text and will open=
web page on click. Assumes the text is a legitimate URL. |
YouTube Formatter |
This displays a YouTube video, based on the I=
D being stored in the field. |
|
Date |
Date |
Displays value as a date =E2=80=93 multiple d=
ate options exist. |
Time |
Displays value as a time field =E2=80=93 mult=
iple date options exist. |
Timestamp |
Displayed full date and time value |
Date Part Formatter |
Takes a date field and formats the display to=
show part of that date. |
|
Numeric |
Numeric |
Displays value as a decimal =E2=80=93 allows =
you to set the decimal places to be used. |
Percentage Bar |
Converts a percentage value less than or equa=
l to 100 into a bar. |