1. Calculation functions
  2. All Functions
  3. Text functions
  4. UPPER

The UPPER function converts text values to uppercase.

Syntax

UPPER(Text [, Locale])

Arguments

ArgumentData typeDescription
Text (required)TextThe text to make uppercase.
LocaleKeyword

The locale to use. Only has an effect with certain languages.

The available locales are based on ISO 639 and ISO 3166 codes.

The UPPER function returns a text value.

Syntax example

UPPER(Business area)

Additional information

Effect of Locale argument

The Locale argument accepts ISO language codes that correspond to the locales available in Java 8. You can use either:

  • Two letter ISO 639 language codes such as en, fr, de, or tr.
  • Four letter codes made of both ISO 639 language codes and ISO 3166 country codes such as en-us, fr-be, de-at, or tr-tr. However you must replace the hyphen (-) with an underscore (_) in Anaplan, so these become en_us, fr_be, de_at, and tr_tr respectively.

The Locale argument only has an effect on certain languages. For example, Turkish, which is represented by the tr code. In Turkish, there are four versions of the character i. Lowercase and uppercase versions, both with and without a dot.

Calculation engine functionality differences

In Polaris, you cannot use the Locale argument with the UPPER function.

In the Classic Engine, you can use the Locale argument.

Excel equivalent

Related Anaplan functions

LOWER

Examples

General example of UPPER

This example has a Territory list on columns, and two line items on rows. The first line item contains the product categories sold in each region. The second line item contains a formula that uses UPPER to make the product categories uppercase, for use in another system.


New YorkSan FranciscoLondonYorkTokyoOsaka
Product categoriesAccessories, Footwear, Innerwear, Outerwear, Sports EquipmentAccessories, Footwear, Sports equipment, Accessories, Footwear, Innerwear, Outerwear, Sports EquipmentOuterwear, Sports EquipmentAccessories, Footwear, Innerwear, Outerwear, Sports EquipmentAccessories, Outerwear, Sports Equipment

Uppercase product categories

UPPER(Product categories)

ACCESSORIES, FOOTWEAR, INNERWEAR, OUTERWEAR, SPORTS EQUIPMENTACCESSORIES, FOOTWEAR, SPORTS EQUIPMENT,ACCESSORIES, FOOTWEAR, INNERWEAR, OUTERWEAR,  SPORTS EQUIPMENTOUTERWEAR, SPORTS EQUIPMENTACCESSORIES, FOOTWEAR, INNERWEAR, OUTERWEAR, SPORTS EQUIPMENTACCESSORIES, OUTERWEAR, SPORTS EQUIPMENT

Example of UPPER with international characters

In this example, a module contains a list of languages on columns. The are two line items on rows, one that contains international characters, and another one that uses the UPPER function to make them uppercase.


Accented characterCyrillicGreekChineseJapaneseKorean
Lowercase characteråжψ

Uppercase character

UPPER(Lowercase character)

ÅЖΨ

The UPPER function works with most languages without the Locale argument. However, it has no effect on certain languages, such as Chinese, Japanese, or Korean, as these languages do not have uppercase or lowercase characters.

Example of the Locale argument

If you use the UPPER function with a text string that contains a lowercase i and use the tr_tr code for the Locale argument, the result contains an uppercase I with a dot, İ.

UPPER("i", tr)

The result of this formula is İ.