Functions
This page lists all of the functions.
You can view lists of functions by theme, using the links in the sidebar on the left.
| Abs | Returns the absolute value of a number. |
| ACos | Computes the arc-cosine, or inverse cosine, of a number. |
| ACosh | |
| Alea | |
| AleaGauss | |
| AlternativeUnitsConvertTo | Converts a quantity of an item from one unit to another, using direct, reversed, or transitive conversions. |
| And (operator) | |
| Annee | |
| ArcCos | |
| ArcCosh | |
| ArcSin | |
| ArcSinh | |
| ArcTan | |
| ArcTanh | |
| AreNumbers | Determines whether or not a series of values are numbers. |
| Arrondi | |
| ASin | |
| ASinh | Returns the inverse hyperbolic sine of a number. |
| ATan | |
| ATanh | |
| Average | Calculates the arithmetic mean of the values in a list of values, range(s), or list(s). |
| BackgroundImage | Returns a string describing a background image. |
| BarChart | Creates a horizontal bar chart in the cell. |
| BatchGPAOID | |
| BatchItem | |
| BatchParameter | |
| BatchPeremptionDate | |
| BatchProperty | |
| BatchProvider | |
| BatchProviderBatch | |
| BatchProviderCertificate | |
| BatchReceivedQuantity | |
| BatchReceptionDate | |
| BatchState | |
| Block | Defines a block of presentation expressions to run sequentially |
| Ceil | Returns the smallest integer greater than or equal to a number. |
| CellName | Returns the cell's name. |
| CellValue | Returns the value of the cell being formatted by the dynamic display. |
| Cherche | Searches for a sub-string of a character string and returns its position. |
| ChildContainer | |
| Chr | Converts a character code into a string. |
| Colonne | |
| ColonneRel | |
| ColorLerp | Calculates an intermediate color between two colors. |
| Column | Returns the column number of the cell to which the function is attached. |
| ColumnRel | |
| ContainerDescription | |
| ContainerGPAOID | |
| ContainerID | |
| ContainerPath | |
| ContainerProperty | |
| ContainerSite | |
| ContainerType | |
| ContainerUMID | |
| Cos | |
| Cosh | |
| Count | Counts the number of non-empty numerical cells in a value set. |
| CountCells | Counts the number of cells in a set of cells. |
| CountEqual | Counts the number of values in a value set that are equal to a specific value. |
| CountIf | Counts the number of values in a value set that meet a condition. |
| CountVal | Counts the number of non-empty cells in a value set. |
| CurrentActualUserLogin | Returns the login of the current actual user. |
| CurrentLanguage | Returns the current language as an IETF BCP 47 . |
| CurrentUserHasKey | Tests if the current user has a particular access key. |
| CurrentUserHasSiteServiceFunction | Tests if the current user has a particular site/service/function. |
| CurrentUserLicense | Returns the license of the current user. |
| CurrentUserLogin | Returns the login of the current user. |
| Date | |
| Day | |
| DayOfWeek | |
| DayOfYear | |
| DecodeDeltaSeries | Returns a list of numbers from a Delta encoded string entered as a parameter. |
| DecodeDeltaSeriesXY | Returns a list of numbers from a Delta encoded string entered as a parameter. |
| Decoupe | Splits a string based on a delimiter and returns a list of sub-elements. |
| Degrees | |
| Degrees | Converts radians into degrees. |
| DegToRad | |
| Depend | Declares an explicit dependency. |
| DocumentViewAppliedURL | Returns a link to the view of the applied version of document whose UDR was entered as a parameter. |
| DocumentViewURL | Returns a link to the view of the document whose reference was entered as a parameter. |
| Droite | |
| EcarType | |
| EcarTypeP | |
| EncodeURIComponent | Encodes a string in URI-encoded format with string normalization. |
| Ent | |
| EpochTimeStamp | Returns the current Epoch TimeStamp on the client workstation. |
| EqptDescription | |
| EqptFamily | |
| EqptGPAOID | |
| EqptID | |
| EqptName | |
| EqptNature | |
| EqptParameter | |
| EqptProperty | |
| EqptStateID | Returns the ID associated to an equipment state technical name. |
| EqptType | |
| EstNum | |
| Etendue | |
| Exp | |
| False | |
| Fill | Determines the color or appearance of the fill for the cell's background. |
| Find | Searches for a sub-string of a character string and returns its position. |
| FKhi2 | |
| FloatToStr | Converts a floating-point value to its character string representation. |
| Floor | Returns the largest integer less than or equal to a number. |
| Fonctions | |
| FontColor | Determines the font color of the text in a cell. |
| FontStyle | Determines the font style of the text in a cell. |
| FormatDateTime | Formats a date/time in the form of a string in a user-defined format. |
| FormatFloat | Converts a floating-point value to a string and specifies the format. |
| Frac | |
| Gauche | |
| GaussRand | |
| GlobalVar | Returns the value of a global variable. |
| GradientPattern | Returns a string describing a gradient. |
| Haversine | Computes the distance on a sphere. |
| Heure | |
| Hour | |
| If | |
| IfError | Returns the first parameter that is not an error. |
| IfFinite | Returns the first parameter that is a finite number. |
| ImportedFileName | |
| ImportedFileProperty | |
| ImportedFileSize | |
| ImportedFileURL | |
| Index | |
| IndexOf | Searches for an element in a list value and returns its index. |
| Int | |
| Interlace | Interlaces two or more lists/values in a list. |
| IntToHex | |
| IntToStr | Converts an integer to its character string representation. |
| InverseFKhi2 | |
| IsError | Determines whether or not a value corresponds to an error. |
| IsFinite | Returns True if the parameter is a finite number. |
| IsNumber | Determines whether or not a value is a number. |
| ISO8601ToDateTime | Datetime in current timezone from an ISO 8601 date. |
| IsValid | |
| ItemBatch | |
| ItemDescription | |
| ItemFamily | |
| ItemGPAOID | |
| ItemName | |
| ItemParameter | |
| ItemPeremption | |
| ItemProperty | |
| ItemSubFamily | |
| ItemTraceGlobal | |
| ItemTraceLocal | |
| ItemUnit | |
| Join | Joins a set of elements in the form of a single string with separators. |
| Jour | |
| JSONParse | Interprets a string in JSON format. |
| JSONPath | Extracts a sub-set of data from a string in JSON format. |
| JSONStringify | Encodes a value in JSON format. |
| LayerName | Returns the name of the cell's layer. |
| Left | Extracts characters from the left end of a string of characters (the first characters). |
| Length | |
| Ligne | |
| LigneRel | |
| Line | |
| LineRel | |
| List | Combines a set of values into a single list value. |
| ListExclude | Excludes items from a list. |
| ListIf | Compute a list of values that meet a condition. |
| ListIntersect | Computes the intersection of multiple lists. |
| ListPack | Deletes empty elements from a set of list values. |
| ListPolynomial | Applies a polynomial to the items of a list. |
| ListRemove | Removes items from a list. |
| ListReverse | Reverses the items of a list. |
| ListSign | Computes the sign of values in a list. |
| ListUnique | Combines a set of values into a single list value with no duplicates. |
| Ln | |
| LocalNow | Returns the current date and time on the client workstation. |
| LocalToUnixTime | UnixTime for the specified datetime in the current workstation timezone. |
| LocalToUtcDateTime | UTC datetime for the specified datetime in the current workstation timezone. |
| Log | |
| Log10 | |
| Lookup | Looks up a value in a search set and returns the corresponding value (with the same Index) in a set of results. |
| LookupAll | Looks up a value in a search set and returns all of the corresponding values (with the same Index) in a set of results. |
| LowerCase | |
| Maintenant | |
| Majuscule | |
| ManufOrdersBatch | |
| ManufOrdersGPAOID | |
| ManufOrdersItem | |
| ManufOrdersManufacturing | |
| ManufOrdersProperty | |
| ManufOrdersState | |
| Max | Calculates the (numerical) maximum out of all of the values in a list of values, ranges and/or lists. |
| Median | |
| Mediane | |
| Mid | |
| Min | Calculates the (numerical) minimum out of all of the values in a list of values, ranges and/or lists. |
| Minuscule | |
| Minute | |
| Mois | |
| Month | |
| Moyenne | |
| Nb | |
| NbCar | |
| NbCells | Alias of CountCells |
| NbChar | |
| NbSi | |
| NBSP | Returns a non-breaking space character. |
| NbVal | |
| Not (operator) | |
| Now | Returns the design or compilation date and time. |
| Numbers | Returns an arithmetic progression of numbers. |
| Or (operator) | |
| ParentContainer | |
| ParentContainerByLevel | |
| PI | |
| Plafond | |
| Plancher | |
| ProviderAddress | |
| ProviderCity | |
| ProviderCountryCode | |
| ProviderDescription | |
| ProviderFax | |
| ProviderGPAOID | |
| ProviderLang | |
| ProviderName | |
| ProviderParameter | |
| ProviderPhone | |
| ProviderProperty | |
| ProviderZipCode | |
| Radians | Converts degrees into radians. |
| RadToDeg | |
| Rand | |
| Range | |
| RangeRatio | |
| ReadContextVar | |
| ReadContextVarDef | |
| ReadEnumerateValue | |
| ReadXListValue | |
| Recherche | |
| RechercheTous | |
| RemoveChars | Deletes a set of characters from a string. |
| Rept | Generates a string of characters by repeating a sub-string. |
| Right | Extracts rightmost characters of a string. |
| Round | Performs rounding to the nearest integer or to an optional number of decimal places. |
| RowID | Returns the row ID for a list view layer. |
| RowIndex | Returns the row number for a list view layer. |
| Second | |
| Seconde | |
| ServerUnixTime | Returns the server unix time. |
| SHA256 | Calculation of a string's hash, as per SHA-256. |
| Si | |
| Sign | Returns a number's sign, in the form of -1, 0 or +1. |
| Sin | |
| Sinh | |
| Slice | Extracts a sub-list from a list. |
| Somme | Alias of Sum. |
| SommeSi | |
| SortByNum | Sorts a list, based on the ascending numerical order of another list. |
| SortByText | Sorts a list, based on the ascending alphabetical order of another list (case insensitive). |
| SortNum | Sorts a list or a list of values by ascending numerical order of the values. |
| SortText | Sorts a list or a list of values by ascending alphabetical order of the values (case sensitive). |
| Split | Splits a string based on a delimiter and returns a list of sub-elements. |
| SQLViewValue | |
| SQLViewValue | |
| Sqrt | Computes the square root of a positive number. |
| StdDev | |
| StdDevP | |
| StrAfter | Extracts string characters after a delimiter. |
| StrBefore | Extracts string characters before a delimiter. |
| StrToDateTime | |
| StrToFloat | |
| StrToFloatDef | |
| STxt | |
| Substitute | |
| Sum | Calculates the numerical sum of the values in a list of values, ranges and/or lists. |
| Sum2 | Calculates the numerical sum of the squared values in a list of values, ranges and/or lists. |
| SumIf | |
| Tan | |
| Tanh | |
| Text | |
| Texte | |
| Time | |
| TimezoneOffset | Timezone offset in minutes for the specified date and time on the client workstation. |
| Traduire | |
| Transitions | Adjust CSS transition |
| Translate | |
| TranslateApplicationString | |
| TranslateConfigurationString | |
| Trim | |
| True | |
| UpperCase | Changes a string of characters to uppercase letters. |
| URLEncode | Encodes a string in URL-encoded format without string normalization |
| UserContract | |
| UserEmail | |
| UserFAX | |
| UserFirstName | |
| UserFunctions | |
| UserGSM | |
| UserID | |
| UserLastName | |
| UserLogin | |
| UserManager | |
| UserPhone | |
| UserProperty | |
| UserService | |
| UserSite | |
| UtcToLocalDateTime | Datetime in current workstation timezone for the specified datetime in UTC. |
| WeekNumber | Returns the week number for the date entered as a parameter (ISO 8601). |
| XListValue | |
| Xor (operator) | |
| Year |