Supported Data and Display Types
A calculated field in PPM Pro can output one of several data types, such as Integer, Float, or String. Within each of those data types, you select a single display type.
The String data type supports String, Textbox, and HTML display types. Note that calculated fields expecting to output HTML must declare themselves as HTML display type. If a field has an incorrect Display Type, its value may show up with markup on the page or report - for example: “<span style="color:red>High</span>" will show in the cell rather than: "High". To correct any problem that arises from this by simply editing the calculated field and changing its Display Type to accurately reflect its output.
The following table shows supported calculated fields data types and their associated display types.
Data Type |
Display Type |
---|---|
Boolean |
Yes/No (default) |
|
Checkbox |
Local Date |
Date (default) |
Local Date Time |
Date & Time |
Float |
Float (default) |
|
Money |
|
Percent (see note) |
Native Percent Note: Data entered in a Native Percent field is assumed a percent and stored and displayed as is, with report output adding a '%'. A Percent field expects a decimal and multiplies the displayed value by 100. For example, if you enter 25 in a Native Percent field, the UI displays 25, and report output displays 25%. If you enter .25 in a Percent field, the UI displays 25, and reports output displays 25%. |
|
Instant |
Date & Time with time zone (default) |
|
Date only |
Integer |
Integer Integer - No format (suppresses things like commas, for example) |
String |
String (default) |
Text box |
|
HTML |
|
Column header |