Follow

Functions supported in the calculated field expression

Text Functions

Function Output Syntax
Replace String, after replacing the old value with the new value in the BaseString. Replace( BaseString, OldValue, NewValue )
Substr Substring of the input string starting from a specified position with a specified length.  Substr( String, From, Length )
Split String array of  substrings from the input string which is delimited by a specified Delimiter. Split( String, Delimiter )
Trim String, which results from the leading and trailing spaces being omitted from the input string. 

Trim( String )

LeftTrim String, which results from the leading spaces being omitted from the input string. 

LeftTrim( String )

RightTrim String, which results from the trailing spaces being omitted from the input string.  RightTrim( String )
PadLeft String, after adding a pad character added to the left of the input string. PadLeft( String, WantedLength, PadChar )
Format String, formatted according to instructions contained in the style string. Format( Expression, Style* )
Lower String, converted to lowercase.  Lower( String )
Upper String, converted to uppercase. Upper( String )
WCase String, converted to wordcase, where the first character of the input string is in uppercase and all the others are in lowercase. WCase( String )
Index Index position of the search text within the input string. Index( String, SearchText, Delimiter )
Len Length of the the input string. Len( String )
Chr The character associated with the specified integer character code. Chr( IntValue )
ChCR A carriage-return character. ChCR()
ChLF A linefeed character. ChLF()
ChCRLF A carriage-return character combined with a linefeed character. ChCRLF()
If TrueValue object if the boolean condition is true, else FalseValue object. If( Boolean_Condition, TrueValue, FalseValue )
Inlist True if search text is present in the list string delimited by a  specified delimiter, else False. Inlist( SearchText, ListString, Delimiter )

 

*Style argument for the Format function may be set as: 

Style

Description

Currency

Displays number with thousand separator, if appropriate; displays two digits to the right of the decimal separator. Output is based on system locale settings.

For example, Format(1234567, "Currency") returns $1,234,567.00.

Fixed

Displays at least one digit to the left and two digits to the right of the decimal separator.

For example, Format(1234567, "Fixed") returns 1234567.00.

Standard

Displays number with thousand separator, at least one digit to the left and two digits to the right of the decimal separator.

For example, Format(1234567, "Standard") returns 1,234,567.00.

Percent

Displays number multiplied by 100 with a percent sign (%) appended immediately to the right; always displays two digits to the right of the decimal separator.

For example, Format(0.4744, "Percent") returns 47.44%.

Scientific

Uses standard scientific notation, providing two significant digits.

For example, Format(1234567, "Scientific") returns 1.23E+06.

Yes/No

Displays No if number is 0; otherwise, displays Yes.

For example, Format(0, "Yes/No") returns No.

True/False

Displays False if number is 0; otherwise, displays True.

For example, Format(1, "True/False") returns True.

On/Off

Displays Off if number is 0; otherwise, displays On.

For example, Format(1, "On/Off") returns On.

 

Numeric Functions

Function Output Syntax
Int Converts the specified object to an Integer value. Int( Object )
Dec Converts the specified object to a floating point decimal value.  Dec( Object )
Rnd A random number.  Rnd()
Round A double precision floating-point value to the nearest integral value. Round( Value )
Abs Unsigned absolute value of the specified object. Abs( Value )
Mod The remainder after division of the two numbers. Mod( Number1, Number2 )
Min Minimum of all the specified numbers. Min( Number1, Number2, [...] )
Max Maximum of all the specified numbers. Max( Number1, Number2, [...] )
Money Currency format of the specified value. Money( Value )

 

Date Functions

Function Output Syntax
Today Date value containing the current date. Today()
Now Date value containing the current date and time. Now()
Date Date value created from the specified year, month and day. Date( Year, Month, Day )
Year Year component of the specified date. Year( Date )
Month Month component of the specified date. Month( Date  )
Day Day of the month represented by the specified date. Day( Date  )
WeekDay Day of the week represented by the specified date. WeekDay( Date )
Long_date Long date string of the specified date (eg: 1st January 2016). Long_date( Date )
Format_date Formatted date string of the specified date as per the specified format string. Format_date( Date, Format* )

 

*Format argument for the Format_date function may be set as one or combination of: 

Format

Description

w

Displays day of the week, i.e., "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday".

For example, Format_date( Date, "w" )

x

Displays the short form of the day of the week, i.e., "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"

For example, Format_date( Date, "x" )

d

Displays the day of the month with two chars as "st", "nd", "rd" or "th" as per the day value.

For example, Format_date( "1/1/2016", "d" ) returns 1st.

e

Displays the day of the month.

For example, Format_date( "1/1/2016", "e" ) returns 1.

f

Displays the day of the month in two digits format.

For example, Format_date( "1/1/2016", "f" ) returns 01.

m

Displays the month of the year, i.e., "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December".

For example, Format_date( "1/1/2016", "m" ) returns January.

n

Displays the month of the year in digit format.

For example, Format_date( "1/1/2016", "n" ) returns 1.

o

Displays the month of the year in two digits format.

For example, Format_date( "1/1/2016", "o" ) returns 01.

p

Displays short form of the month of the year, i.e., "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec".

For example, Format_date( "1/1/2016", "m" ) returns Jan.

y

Displays the year component of the date.

For example, Format_date( "1/1/2016", "y" ) returns 2016.

z

Displays the year component of the date in two digits format.

For example, Format_date( "1/1/2016", "z" ) returns 16.

d m y

A combination of day month and year.

For example, Format_date( "1/1/2016", "d m y" ) returns 1st January 2016.

 

User Functions

Function Output Syntax
UserEmail Email address of the selected user. UserEmail( USERS_FIELD )
UserCellPhone Cell phone number of the selected user. UserCellPhone( USERS_FIELD )
UserHomePhone Home phone number of the selected user. UserHomePhone( USERS_FIELD )
UserWorkPhone Work phone number of the selected user. UserWorkPhone( USERS_FIELD )

 

Here, USERS_FIELD is the field name of a Users type field. For the above four system functions the supported function argument can be a field of type Assignee or Users.

 

Math Functions

Function Output Syntax
Sqrt Square root of the specified number. Sqrt( Number )
Power Specified number raised to the specified power. Power( Number1, Number2 )
Pi The constant value of the ratio of the circumference of a circle to its diameter. Pi()
Sin The sine of the specified value. Sin( Value )
Cos The cosine of the specified value. Cos( Value )

 

Have Questions?

If you have further questions, please feel free to contact us and we will be happy to assist you.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk