The code of the current account (if the Account option is selected in the Expand field in the Data source editor).

The code of the current subaccount (if the Sub option is selected in the Expand field in the Data source editor).

The description of the current account (if the Account option is selected in the Expand field in the Data source editor).

The description of the current subaccount (if the Sub option is selected in the Expand field in the Data source editor).

The last account group in the range of account groups used in the report. Refers to the value in the End account field in the Default data source section section.

Note: This parameter is valid only in the reports of the PM type.

The last project in the range of projects used in the report. Refers to the value in the End project field in the Default data source section section.

Note: This parameter is valid only in the reports of the PM type.

The last project tasks in the range of the project tasks used in the report. Refers to the value in the End task field in the Default data source section section.

Note: This parameter is valid only in the reports of the PM type.

The first account group in the range of account groups used in the report. Refers to the value in the Start account field in the Default data source section section.

Note: This parameter is valid only in the reports of the PM type.

Adds the value of one numeric expression to another or concatenates two strings.

Example: =A10+B10

Here, A10 and B10 are cell references. If the values in the cells are 12.85 and 2.25, the result of the expression would be 12.85 + 2.25 = 15.1.

Subtracts the value of one numeric expression from another.

Example: =A20-B30

Here, A20 and B30 are cell references. If the values in the cells are 12.85 and 2.25, the result of the expression would be 12.85 - 2.25 = 10.6.

Multiplies the value of two expressions.

Example: =C10*D10

Here, A20 and B30 are cell references. Assuming that the parameters have the values C10 = 2.25 and D10 = 2, the example would evaluate to 2.25 * 2 = 4.5.

Divides the values of two expressions.

Example: =A10/C10.

Here, A10 and C10 are cell references. If the values in the cells are 4.0 and 2.0, the result of the expression would be 4.0 / 2.0 = 2.0.

Divides two numbers and returns only the remainder.

Example: =B15 % C15

Here, B15 and C15 are cell references. If the values in the cells are 15.0 and 6.0, the result of the expression would be 3.0.

Performs logical conjunction on two Boolean expressions. If both expressions evaluate to True, then the operator returns True; if either or both expressions evaluate to False, And returns False.

Example: =(A10>0) And (C10>0)

In this example, A10 and C10 are cell references. If A10 = 10 and C10 = 20, then the expression would evaluate to True. Alternatively, f A10 = -10 and C10 = 20, the expression would evaluate to False.

Performs logical disjunction on two Boolean expressions. If either expression evaluates to True, the operation returns True; if neither expression evaluates to True, Or returns False.

Example: =(A10>0) Or (C10>0)

In this example, A10 and C10 are cell references. If A10 = 10 and C10 = 20, then the expression would evaluate to True. Alternatively, f A10 = -10 and C10 = -20, the expression would evaluate to False.

Performs logical negation on a Boolean expression, yielding the opposite of the expression it evaluates. If the expression evaluates to True, the operator yields False; alternatively, if the expression evaluates to False, Not yields True.

Example: =Not (A10>C10)

In this example, A10 and C10 are cell references. If A10 is larger than C10, then the expression would evaluate to False. Alternatively, if A10 is smaller than C10, the expression would evaluate to True.

Equality operator.

Example: =(A10=B10)

In this example, A10 and B10 are cell references. If the value in the A10 cell is equal to the value in C10, then the expression evaluates to True, otherwise the expression evaluates to False.

Inequality operator.

Example: =(C10<>A10)

(where A10 and C10 are the links used as a formula parameters)

In this example, A10 and C10 are cell references. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

The less than operator.

Example: =(@10<@12) (where @10 and @12 are the links to cells in the current column)

In this example, @10 and @12 are the links to cells in the current column. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

Greater than operator.

Example: =(C10>A10) (where A10 and C10 are the links used as a formula parameters)

In this example, A10 and C10 are cell references. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

The less than or equal to operator.

Example: =(C10<=A10) (where A10 and C10 are the links used as a formula parameters)

In this example, A10 and C10 are cell references. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

The greater than or equal to operator.

Example: =(A10>=A10) (where A10 and C10 are the links used as a formula parameters)

In this example, A10 and C10 are cell references. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

This operator is used in an elementary logical expression that evaluates the search results and returns True when the parameter matches one of the elements from the set of values.

Example: =(A20 In (10, 50, 57)) (where A20 is the link used as a formula parameter)

This operator is used as a parameter in logical expressions.

Example: =((D30<A30)=True) (where D30 is the link used as a formula parameter)

This operator is used as a parameter in logical expressions.

Example: =((C10=E10)=False) (where C10 and E10 are the links to the data)

This operator is used as a parameter in logical expressions.

Example: =(@20=Null) (where @20 is the cell in the current column and 10th row)

Converts an expression defined in a function argument into the Boolean expression. If the expression is zero, False is returned; otherwise, True is returned.

Example: =CBool(A11+B11-C11*0.05) (where A11, B11 and C11 are the links used in a function argument)

Converts an expression defined in a function argument to a value of the Date type. The CDate function argument should be a valid date expression. CDate recognises date formats according to the locale setting of the system.

Example: =CDate(A2-B2) (where A2 and B2 are the links used in a function argument)

Converts an expression defined in a function argument to a string. If the CStr function argument equals null, CStr returns a run-time error; otherwise, it returns a string of characters.

Example: =CStr(A12) (where A12 is the link used in a function argument)

Converts an expression defined in a function argument to a value of the Double type.

Example: =CDbl(A12/B2) (where A12 and B2 are the links used in a function argument)

Converts an expression defined in a function argument to a value of the Single type. If the expression defined in the function argument lies outside the acceptable range for the Single type, an error occurs.

Example: =CSng(A12) (where A12 is the link used in a function argument)

Converts an expression defined in a function argument to a value of the Decimal type.

Example: =CDec(A12*0.15) (where A12 is the link used in a function argument)

Converts an expression defined in a function argument to a value of the Integer type.

Example: =CInt(A10) (where A10 is the link used in a function argument)

Converts a numeric value to a value of the Short type.

Example: =CShort(B2) (where B2 is the link used in a function argument)

Converts a numeric value to a value of the Long type.

Example: =CLong(B12) (where B12 is the link used in a function argument)

Removes all leading spaces or parsing characters from the specified character expression, or all leading zero bytes from the specified binary expression.

Example: =LTrim(CStr(A12)) (where A12 is the link used in a function argument)

Removes all trailing spaces or parsing characters from the specified character expression, or all trailing zero bytes from the specified binary expression.

Example: =RTrim(CStr(A12)) (where A12 is the link used in a function argument)

Removes all trailing spaces or parsing characters from the specified character expression, or all trailing zero bytes from the specified binary expression.

Example: =Trim(CStr(A12)) (where A12 is the link used in a function argument)

Replaces the format item in a specified formatting string ( format ) with the text equivalent of the arguments ( arguments ).

Example: =Format('Currency:........ {0:C}; Account:........ {1:N}', A1, B1) (where A1 and B1 are the links used as a function arguments; 0, 1 are the specifiers indicating where the arguments will be inserted; C is the currency format specifier; and N is the number format specifier)

Returns a string that has been converted to upper case. The string argument is any valid string expression. If string contains a null value, the null value is returned.

Example: =UCase(CStr(A12)) (where A12 is the link used in a function argument)

Returns a string that has been converted to lower case. The string argument is any valid string expression. If string contains a null value, the null value is returned.

Example: =LCase(CStr(A12)) (where A12 is the link used in a function argument)

Returns the position of the first occurrence of one string ( findString ) within another ( string ).

Example: =InStr(CStr(A12), 'rur') (where A12 is the link used in a function argument)

Returns the position of the last occurrence of one string ( findString ) within another ( string ), starting from the right side of the string.

Example: =InStrRev(CStr(A12), 'rur') (where A12 is the link used in a function argument)

Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable.

Example: =Len(CStr(A12)) (where A12 is the link used in a function argument)

Returns a string containing a specified number of characters from the left side of a string. If string contains the null value, the null value is returned.

Example: =Left(CStr(A12), 3) (where A12 is the link used in a function argument)

Returns a string containing a specified number of characters from the right side of a string. If string contains a null value, the null value is returned.

Example: =Right(CStr(A12), 3) (where A12 is the link used in a function argument)

Returns a string in which a specified sub string ( oldValue ) has been replaced with another sub string ( newValue ).

Example: =Replace(CStr(A12), 'rur', 'eur') (where A12 is the link used in a function argument)

Right-aligns the characters in a specified string ( string ), padding with the specified characters ( paddingChar ) on the left for a specified total width ( width ).

Example: =PadLeft(CStr(A12), 3, '%') (where A12 is the link used in a function argument)

Left-aligns the characters in a specified string ( string ), padding with the specified characters ( paddingChar ) on the right for a specified total width ( width ).

Example: =PadRight(CStr(A12), 3, '%') (where A12 is the link used in a function argument)

Returns the absolute value of a number.

Example: =Abs(A10-B10)

Here A10 and B10 are the links used in a function argument.

Returns the largest integer that is not greater than the argument.

Example: =Floor(A10-A12)

Here A10 and A12 are the links used in a function argument.

Returns the smallest integer that is not less than the argument.

Example: =Ceiling(A10-C11)

Here A10 and C11 are the links used in a function argument.

Returns a numeric expression, rounded to the specified precision ( decimals ).

Example: =Round((A10-B12), 5)

Here A10 and B12 are the links used in a function argument, and 5 is the number of digits after the decimal separator.

Returns the smaller of the two values.

Example: =Min(A10, A12) =Min(A10, 12)

Here A10 and A12 are the links used as function arguments)

Returns the greater of the two values.

Example: =Max(A12, A14) =Max(A12, 240)

Here A12 and A14 are the links used as function arguments.

Computes the value of x raised to the specified power ( power ).

Example: =Pow((A12, 2))

Here A12 is the link used as a function argument, and 2 is the power index.

Returns the current date and time according to the system date and time on the local computer.

Example: =Now()

Returns the current date according to the system date and time on the local computer.

Example: =Today()

Returns the current date and time according to the user’s time zone.

The system gets the user’s time zone from the following sources, which are ordered by the priority from the highest to the lowest:

1. User’s preferences specified in the User settings (SM203010) window.
2. The employee calendar specified in the Work calendar (CS209000) window and selected for the user’s employee in the Employees (EP203000) window.

Example: =NowUTC()

Returns the current date according to the user’s time zone.

The system gets the user’s time zone from the following sources, which are ordered by the priority from the highest to the lowest:

1. User’s preferences specified in the User settings (SM203010) window.
2. The employee calendar specified in the Work calendar (CS209000) window and selected for the user’s employee in the Employees (EP203000) window.

Example: =TodayUTC()

Returns the new date calculated as a date parameter to which the specified time interval has been added.

The interval argument is a string expression that is the interval to be added. This argument can have the following values:

yyyy

year (a number of years will be added to a date )

m

month (a number of months will be added to a date )

y

day of year (same as day )

d

day (a number of days will be added to a date )

h

hour (a number of hours will be added to a date )

n

minute (a number of minutes will be added to a date )

s

second (a number of seconds will be added to a date )

The number is the numeric expression that is the number of intervals to be added. The numeric expression can either be positive, for dates in the future, or negative, for dates in the past. The date argument is the date to which interval is added.

Example: =DateAdd(CDate('31/01/1995'), 'm', -2) =DateAdd(Today(), 'y', 3) =DateAdd(Now(), 'd', 1)

Returns the year component of the date.

Example: =Year(Now())

Returns the month component of the date.

Example: =Month(Now())

Returns the day component of the date.

Example: =Day(Now())

Returns the day of week for a date.

Example: =DayOfWeek(Today())

Returns the day of the year for a date.

Example: =DayOfYear(Now())

Returns the minutes for a date.

Example: =Minute(Now())

Returns the second component of the date.

Example: =Second(Now())

Returns one of two values, depending on the evaluation of an expression. If the expression evaluates to True, the function returns the truePart value; otherwise, it returns falsePart value.

Example: =IIf((A10-B10)<>0), CStr(A12), 'No data available') (where A10, A12, and B10 are the links used as a function arguments)

Returns one of the values, depending on the evaluation of the expressions in the parameter. The function returns the value_n, which corresponds to the first expression in the enumeration that evaluates to True.

Example: =Switch(((A10-B10)<>0), A12, ((A10-B10)>0), B35)

Returns nullValue, if value is NULL; otherwise, returns value.

Example: =IsNull(A10, '0') (if A10 is NULL, returns 0, otherwise returns the A10 value)

Returns the sum of the values in the specified interval.

Example: =Sum('A11','A100') (where A11 and A100 are the links used in a function argument)

Returns the values in the specified range of rows in the specified column sorted in ascending order.

Example: Sort('0100','0145','B') (the values in rows from ‘0100’ to ‘0145’ in the ‘B’ column will be sorted in ascending order)

Returns the values in the specified range of rows in the specified column sorted in descending order.

Example: SortD('0100','0145','B') (the values in rows from ‘0100’ to ‘0145’ in the ‘B’ column will be sorted in descending order)