Applicable Product:

• OrgPublisher

Applicable Release:

• V21 and later
• 11.9 and later with HTML5 publishing

Summary:

In OrgPublisher, the decimal symbol used by default is the period/full-stop.  In order to display a numeric value with a comma for the decimal separator, as used in European countries, a custom Text field must be used in conjunction with the Formula function.  Here's how:

Note: In this example, the numeric field is called FTE

1. Create a new custom field and set its type to "Text" - in this example, the field is called FTEDisplay
2. In the "Formula" tab, enter this formula:

   return = Replace("$FTE$", ".", ",")

3. Then save the formula
4. Use this new field in your Profile View or in the Box formatting to display it
    
    
     
   Keywords:
   
   
   Created : Alvin Ee
   Reviewed: Melanie Culp 12/13/2023