CapFirstLetter function

Applies to: TBM Studio 12.0 and later

Capitalizes the first letter of each word in the string argument, and makes all other letters lowercase.

Where to use

This function can be used in:
  • Data sets
  • Calculated metrics and reports with metric columns
  • Formula columns in report tables
  • Dynamic text

Syntax

CapFirstLetter(string)

Arguments

string

One or more words.

Return type

String

Example

The following would return "Data Center Budget."

=CapFirstLetter(DATA CENTER BUDGET)

See also