{"id":33787,"date":"2024-10-18T15:17:53","date_gmt":"2024-10-18T14:17:53","guid":{"rendered":"https:\/\/developers.ila.cegid.com\/vision\/\/"},"modified":"2025-11-10T13:30:33","modified_gmt":"2025-11-10T12:30:33","slug":"formulas-in-queries","status":"publish","type":"vision","link":"https:\/\/developers.ila.cegid.com\/en\/vision\/documentation\/consultations\/article\/formulas-in-queries","title":{"rendered":"Formulas in Queries"},"content":{"rendered":"<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock  '   itemprop=\"text\" ><p>Vision allows you to obtain new columns of data as a result of the definition of formulas, by using a simple syntax or language. Each formula has a type associated with it, which does not need to be defined: Vision determines it automatically according to what the grammar indicates.<\/p>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock  '   itemprop=\"text\" ><h2>Add Formulas<\/h2>\n<p>Formulas can be added in two ways:<\/p>\n<ul>\n<li>As columns of a dataset, making them available as another field in any query dialog.<br \/>\nIn the query associated to a widget in an app, by including them in a <strong>Select<\/strong> block.<\/li>\n<\/ul>\n<p>In the formula editor there is a space where the formula expression is written. The user can type it directly if he\/she knows the language and wishes to do so, but to facilitate the task the editor has some useful resources:<\/p>\n<ol>\n<li>Components: section with the available fields to include in the formula, separated according to whether they are dimensions (date or text) or measures. In the case of formulas in datasets it has all the fields of the dataset, and in the case of a formula in a widget query it has the fields that reach the Select block where the formula is defined.<\/li>\n<li><strong>Functions<\/strong>: allows you to select the function or operation you want to include. There are a large number of functions available for the formula language to perform complex calculations, which are described in the following section.<\/li>\n<li><strong>Variables<\/strong>: includes certain variables or values relevant for use in formulas. There are 3 types:\n<ul>\n<li><strong>Static: <\/strong>\n<ul>\n<li><strong><em>null<\/em>:<\/strong> equivalent to the null, empty or unreported value of a field.<\/li>\n<li><strong><em>now<\/em>\u00a0y\u00a0<em>today<\/em>:<\/strong> both correspond to the current date, the former to the millisecond, and the latter truncated to the day.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Subqueries:<\/strong> the natural use of subqueries is through formulas. Each subquery is calculated independently of an application&#8217;s widgets, and returns a set of data arranged in rows (maximum 12) and fields. In a formula, a value can be selected by indicating the field and row of a subquery (0 ? first row, 1 ? second row, etc.), or include all values as an array. The variable is written as a special expression, from the syntax <strong>&#8220;&#8221;<code>$SQ_subqueryName_columnName__N<\/code>&#8220;&#8221;.<\/strong><\/li>\n<li><strong>Filters: <\/strong>allows you to include selected values in filters. You can select a value indicating the field and position in its ordered list of values (0 ? first row, 1 ? second row, etc.), or include all values as an array. In the second case the recommendation is to use fields with &#8220;&#8221;short&#8221;&#8221; list of values, since a list with many values (thousands) directly affects the performance of the query. The variable is written as a special expression, from the syntax <strong>&#8220;&#8221;<code>$FILTER_columnName__N<\/code>&#8220;&#8221;.<\/strong><\/li>\n<li><strong>Scenarios: <\/strong>the natural use of scenarios is through formulas. Any defined toggle or scenario is accessible as a variable: the value selected by the user will be the one transmitted to the formula through its variable; the variable is written as a special expression, with the syntax <strong>&#8220;&#8221;<code>$shifterName<\/code>&#8220;&#8221;.<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Interactive Help<\/strong>: when typing text, the editor displays the options that match the text that the user types, either components, functions or variables. In addition, in the case of functions, a tooltip with their description is displayed.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33785\" src=\"https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/View-Vision-Formulas.png\" alt=\"\" width=\"4400\" height=\"2387\" srcset=\"https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/View-Vision-Formulas.png 4400w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/View-Vision-Formulas-300x163.png 300w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/View-Vision-Formulas-1030x559.png 1030w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/View-Vision-Formulas-768x417.png 768w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/View-Vision-Formulas-1536x833.png 1536w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/View-Vision-Formulas-2048x1111.png 2048w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/View-Vision-Formulas-1500x814.png 1500w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/View-Vision-Formulas-705x382.png 705w\" sizes=\"auto, (max-width: 4400px) 100vw, 4400px\" \/><\/p>\n<p style=\"text-align: center;\"><em>Example of the formula editor<\/em><\/p>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock  '   itemprop=\"text\" ><h2 id=\"\">Use Functions<\/h2>\n<p>The <strong>Functions<\/strong> tab contains all operations and calculations that can be performed in the formula dialog. There are several categories, depending on the input\/output of the function, each with its associated block in the function list:<\/p>\n<p><strong>Categories<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td align=\"\">Arrays<\/td>\n<td align=\"\">Comparison<\/td>\n<td align=\"\">Conditionals<\/td>\n<td align=\"\">Conversion<\/td>\n<td align=\"\">Dates<\/td>\n<\/tr>\n<tr>\n<td align=\"\">Logics<\/td>\n<td align=\"\">Mathematics<\/td>\n<td align=\"\">Operators<\/td>\n<td align=\"\">Text<\/td>\n<td align=\"\">Trigonometric<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24549\" src=\"https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/app.widget.consulta.seleccionar.formulas-funciones.png\" alt=\"\" width=\"1290\" height=\"799\" srcset=\"https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/app.widget.consulta.seleccionar.formulas-funciones.png 1290w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/app.widget.consulta.seleccionar.formulas-funciones-300x186.png 300w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/app.widget.consulta.seleccionar.formulas-funciones-1030x638.png 1030w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/app.widget.consulta.seleccionar.formulas-funciones-768x476.png 768w, https:\/\/developers.ila.cegid.com\/wp-content\/uploads\/app.widget.consulta.seleccionar.formulas-funciones-705x437.png 705w\" sizes=\"auto, (max-width: 1290px) 100vw, 1290px\" \/><img class=\"\" alt=\"\" width=\"\" height=\"\" \/><\/p>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock  '   itemprop=\"text\" ><p style=\"text-align: center;\"><em>Formula editor showing function classes<\/em><\/p>\n<p><strong>Note<\/strong>: In case of using text strings with special characters, such as <code>\"\",+,%<\/code> or others, as function arguments, they must be preceded by the backslash <span data-olk-copy-source=\"MessageBody\">\\<\/span> so that they are interpreted as part of the text string and not as special symbols.<\/p>\n<\/div><\/section>\n<div   class='hr hr-default  '><span class='hr-inner ' ><span class='hr-inner-style'><\/span><\/span><\/div>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Arrays<\/h3>\n<p>These functions are special in that they handle arrays or ordered sets of data as arguments. They are mainly used to handle the results of subqueries or lists of filter values.<\/p>\n<p><center>Functions<\/center><\/p>\n<table style=\"width: 100.967%;\">\n<tbody>\n<tr>\n<td style=\"width: 30.719%;\" align=\"\">Contains the value<\/td>\n<td style=\"width: 27.342%;\" align=\"\">Array element<\/td>\n<td style=\"width: 31.9172%;\" align=\"\">Value position<\/td>\n<td style=\"width: 11.1111%;\">Array size<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30.719%;\" align=\"\">contains(A, v)<\/td>\n<td style=\"width: 27.342%;\" align=\"\">elementAt(A, i)<\/td>\n<td style=\"width: 31.9172%;\" align=\"\">indexOfArray(A, v)<\/td>\n<td style=\"width: 11.1111%;\">size(A)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Contains the value<\/h4>\n<p><strong><em>Syntax: contains(Array, value)<\/em><\/strong><\/p>\n<p>Checks if value is contained in the set of elements in Array form, as for example happens with the result of a subquery. Returns true if the expression is part of the array or false otherwise.<\/p>\n<p>Example:<\/p>\n<table>\n<thead>\n<tr>\n<th>EXAMPLE<\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>contains([&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;, &#8220;&#8221;c&#8221;&#8221;], &#8220;&#8221;a&#8221;&#8221;)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>contains([&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;, &#8220;&#8221;c&#8221;&#8221;], &#8220;&#8221;d&#8221;&#8221;)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>contains($SQ_Field_Var, [Column])<\/em><\/td>\n<td>Returns true if the value of the <strong>Column<\/strong> field belongs to the set of values of the Field field returned by the <strong>SQ<\/strong> subquery, and false otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Array element<\/h4>\n<p><strong><em>Syntax: elementAt(Array, index)<\/em><\/strong><\/p>\n<p>Returns the value or element of the array located at the &#8220;&#8221;index&#8221;&#8221; position. Note that an array of N elements has indexes from 0 to N-1, if the index is greater than N-1 it is returned empty.<\/p>\n<p>Example:<\/p>\n<table>\n<thead>\n<tr>\n<th>EXAMPLE<\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>elementAt([&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;, &#8220;&#8221;c&#8221;&#8221;], 0)<\/em><\/td>\n<td><em>a<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>elementAt([&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;, &#8220;&#8221;c&#8221;&#8221;], 2)<\/em><\/td>\n<td><em>c<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>elementAt([&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;, &#8220;&#8221;c&#8221;&#8221;], 3)<\/em><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><em>elementAt($SQ_Field_Var, [Column])<\/em><\/td>\n<td>Returns the element with index equal to the value of the numeric field <strong>Column<\/strong> from the set of values of the field <strong>Field<\/strong> returned by the subquery <strong>SQ<\/strong>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Value position<\/h4>\n<p><strong><em>Syntax: indexOfArray(Array, value)<\/em><\/strong><\/p>\n<p>Checks if value is contained in the set of elements in Array form, as for example happens with the result of a subquery. Returns the number equal to the index of the element equal to value if the expression is part of the array or -1 otherwise. Note that an array of N elements has indexes from 0 to N-1.<\/p>\n<p>Example:<\/p>\n<table>\n<thead>\n<tr>\n<th>EXAMPLE<\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>indexOfArray([&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;, &#8220;&#8221;c&#8221;&#8221;], &#8220;&#8221;a&#8221;&#8221;)<\/em><\/td>\n<td><em>0<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>indexOfArray([&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;, &#8220;&#8221;c&#8221;&#8221;], &#8220;&#8221;c&#8221;&#8221;)<\/em><\/td>\n<td><em>2<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>indexOfArray([&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;, &#8220;&#8221;c&#8221;&#8221;], &#8220;&#8221;d&#8221;&#8221;)<\/em><\/td>\n<td><em>-1<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>indexOfArray($SQ_Field_Var, [Column])<\/em><\/td>\n<td>Returns the index of the <strong>Column<\/strong> field value if it belongs to the set of <strong>Field<\/strong> field values returned by the <strong>SQ<\/strong> subquery, and -1 otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"tama\u00f1o-del-array\">Array size<\/h4>\n<p>Syntax: <em>size(Array)<\/em><\/p>\n<p>Returns a numeric value equal to the number of elements or size of the <em>Array<\/em>. All elements in the array must be of the same type.<\/p>\n<p>Examples:<\/p>\n<div class=\"pri_table_wrapper\">\n<table>\n<thead>\n<tr>\n<th><strong>Example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>size([&#8220;a&#8221;, &#8220;b&#8221;])<\/em><\/td>\n<td><em>2<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>size([15,29,33])<\/em><\/td>\n<td><em>3<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>size([])<\/em><\/td>\n<td><em>0<\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Comparison (equality)<\/h3>\n<p>Functions<\/p>\n<table style=\"width: 99.0316%;\">\n<tbody>\n<tr>\n<td style=\"width: 345px;\" align=\"\">Comparison<\/td>\n<td style=\"width: 282px;\" align=\"\">Equal<\/td>\n<td style=\"width: 294px;\" align=\"\">Not equal<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 345px;\" align=\"\">cmp(v1,v2)<\/td>\n<td style=\"width: 282px;\" align=\"\">eq(v1,v2)<\/td>\n<td style=\"width: 294px;\" align=\"\">ne(v1,v2)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4>Comparison<\/h4>\n<p><em>Syntax: cmp(value1, value2)<\/em><\/p>\n<p>Compares the type and value of the two arguments:<\/p>\n<ul>\n<li>If the types are equal it returns 1 if the first value is greater than the second, -1 if less and 0 if they are equal.<\/li>\n<li>If the types are different, it follows the order criteria from lowest to highest: null, number, text, array, boolean (true, false) and date.<\/li>\n<\/ul>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>cmp(1, &#8220;&#8221;a&#8221;&#8221;)<\/em><\/td>\n<td><em>-1<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>cmp(1, 1)<\/em><\/td>\n<td><em>0<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>cmp(1, 2)<\/em><\/td>\n<td><em>-1<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>cmp(2, 1)<\/em><\/td>\n<td><em>1<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>cmp(&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;)<\/em><\/td>\n<td><em>-1<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>cmp(false, 1)<\/em><\/td>\n<td><em>1<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>cmp(1, $null)<\/em><\/td>\n<td><em>1<\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"\">Equal<\/h4>\n<p><em>Syntax: eq(value1, value2)<\/em><\/p>\n<p>Compares two values against each other, and returns true if the two values and their types are equal, and false otherwise.<\/p>\n<p>Example:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>eq(3, 15)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>eq(3, 3)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>eq(3, &#8220;&#8221;3&#8243;&#8221;)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>eq([Column], 15)<\/em><\/td>\n<td>true if the value of the <strong>Column<\/strong> field is equal to the number 15, and false otherwise.<\/td>\n<\/tr>\n<tr>\n<td><em>eq([Column], $null)<\/em><\/td>\n<td>true if the value of the <strong>Column<\/strong> field is null (empty) and false otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"\">Not equal<\/h4>\n<p><em>Syntax: ne(value1, value2)<\/em><\/p>\n<p>Compares two values against each other, and returns true if the two values or their types are different, and false otherwise.<\/p>\n<p>Example:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>ne(3, 15)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>ne(3, 3)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>ne(3, &#8220;&#8221;3&#8243;&#8221;)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>ne([Column], 15)<\/em><\/td>\n<td>false if the value of the <strong>Column<\/strong> field is equal to the number 15, and true otherwise.<\/td>\n<\/tr>\n<tr>\n<td><em>ne([Column], $null)<\/em><\/td>\n<td>false if the value of the <strong>Column<\/strong> field is null (empty) and true otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Comparison (greater\/lower)<\/h3>\n<h4 id=\"\">Greater or equal<\/h4>\n<p><em>Syntax: gte(value1, value2)<\/em><\/p>\n<p>Compares two values against each other, and returns true if the first value is greater than or equal to the second and their types are equal, and false otherwise.<\/p>\n<p>Examples<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>gte(3, 15)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>gte(3, 3)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>gte(15, 3)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>gte(&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>gte([Column], 15)<\/em><\/td>\n<td>true if the value of the <strong>Column<\/strong> field is greater than or equal to 15 and false otherwise.<\/td>\n<\/tr>\n<tr>\n<td><em>gte(0, $null)<\/em><\/td>\n<td>true, the order criteria between types is from lowest to highest: null, number, text, array, boolean (true, false) and date.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"\">Greater<\/h4>\n<p><em>Syntax: gt(value1, value2)<\/em><\/p>\n<p>Compares two values against each other, and returns true if the first value is greater than the second and their types are equal, and false otherwise.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>gt(3, 15)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>gt(3, 3)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>gt(15, 3)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>gt(&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>gt([Column], 15)<\/em><\/td>\n<td>true if the value of the <strong>Column<\/strong> field is greater than 15 and false otherwise.<\/td>\n<\/tr>\n<tr>\n<td><em>gt(0, $null)<\/em><\/td>\n<td>true, the order criteria between types is from lowest to highest: null, number, text, array, boolean (true, false) and date.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"\">Lower or equal<\/h4>\n<p><em>Syntax: lte(value1, value2)<\/em><\/p>\n<p>Compares two values with each other, and returns true if the first value is less than or equal to the second and their types are equal, and false otherwise..<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>lte(3, 15)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>lte(3, 3)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>lte(15, 3)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>lte(&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>lte([Column], 15)<\/em><\/td>\n<td>true if the value of the <strong>Column<\/strong> field is less than or equal to 15 and false otherwise.<\/td>\n<\/tr>\n<tr>\n<td><em>lte(0, $null)<\/em><\/td>\n<td>false, the order criteria between types is from lowest to highest: null, number, text, array, boolean (true, false) and date.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"\">Lower<\/h4>\n<p><em>Syntax: lt(value1, value2)<\/em><\/p>\n<p>Compares two values against each other, and returns true if the first value is less than the second and their types are equal, and false otherwise.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>lt(3, 15)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>lt(3, 3)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>lt(15, 3)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>lt(&#8220;&#8221;a&#8221;&#8221;, &#8220;&#8221;b&#8221;&#8221;)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>lt([Column], 15)<\/em><\/td>\n<td>true if the value of the <strong>Column<\/strong> field is less than 15 and false otherwise.<\/td>\n<\/tr>\n<tr>\n<td><em>lt(0, $null)<\/em><\/td>\n<td>false, the order criteria between types is from lowest to highest: null, number, text, array, boolean (true, false) and date.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Conditionals<\/h3>\n<p>Conditional functions, which are very frequently used, allow you to change the conditions for the transformation of the original fields. They are the following:<\/p>\n<p><center>Functions<\/center><\/p>\n<table>\n<tbody>\n<tr>\n<td align=\"\">Simple conditional<\/td>\n<td align=\"\">Multiple conditional<\/td>\n<td align=\"\">If null<\/td>\n<\/tr>\n<tr>\n<td align=\"\">cond(b, v1, v2)<\/td>\n<td align=\"\">switch(b1, v1; b2, v2; &#8230; ; v)<\/td>\n<td align=\"\">ifNull(v, r)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Simple conditional<\/h4>\n<p><em>Syntax: cond(boolean, value1, value2)<\/em><\/p>\n<p>The first argument is a boolean (true or false), for example the result of a comparison function. If boolean equals true the function returns value1, otherwise value2. In addition, value1 and value2 must necessarily have the same data type.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>cond(true, 1, 0)<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td><em>cond(false, 1, 0)<\/em><\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td><em>cond(eq(1, &#8220;&#8221;1&#8243;&#8221;), 1, 0)<\/em><\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td><em>cond(gt(5, 2<\/em>2), 1, 0)*<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td><em>cond(gt([Reference], 100), [Column1], [Column2])<\/em><\/td>\n<td>Returns the value of the <strong>Column1<\/strong> field if the value of the <strong>Reference<\/strong> column is greater than 100, and the value of the <strong>Column2<\/strong> field otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Multiple conditional<\/h4>\n<p><em>Syntax: switch(boolean1, value1; boolean2, value2; &#8230;; value)<\/em><\/p>\n<p>The function receives pairs of values (boolean, value) separated by &#8220;&#8221;;&#8221;&#8221;. If boolean1 is equal to true the function returns value1, otherwise it goes to the next pair; if boolean2 is equal to true the function returns value2, otherwise it goes to the next pair; this process is repeated as many times as pairs (boolean, value) are indicated; finally, if all boolean are false, value is returned. Particularities:<\/p>\n<ul>\n<li>At least 2 conditions must be defined, otherwise the simple conditional function must be used.<\/li>\n<li>The default value is not mandatory, a null value is returned if not defined.<\/li>\n<\/ul>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>switch(true, 1; false, 2; 0)<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td><em>switch(false, 1; false, 2)<\/em><\/td>\n<td>null<\/td>\n<\/tr>\n<tr>\n<td><em>switch(eq(1, &#8220;&#8221;a&#8221;&#8221;), 1; eq(1, true), 2; eq(1, 1), 3; 0)<\/em><\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<td><em>switch(eq(1, &#8220;&#8221;a&#8221;&#8221;), 1; eq(1, true), 2; eq(1, 2), 3; 0)<\/em><\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td><em>switch(lt([Column], 5), &#8220;&#8221;lt&#8221;&#8221;; gt([column], 5), &#8220;&#8221;gt&#8221;&#8221;; &#8220;&#8221;eq&#8221;&#8221;)<\/em><\/td>\n<td>If the value of the numeric field <strong>Column<\/strong> is less than 5 it returns &#8220;&#8221;lt&#8221;&#8221;, if greater &#8220;&#8221;gt&#8221;&#8221;, and &#8220;&#8221;eq&#8221;&#8221; in all other cases.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>If null<\/h4>\n<p><em>Syntax: ifNull(value, replacement)<\/em><\/p>\n<p>The ifNull function allows to replace the null values of a column by another value. If value has a null value, the function returns replacement, otherwise value. It is mandatory that replacement has the same data type as value.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>ifNull(0, 1)<\/em><\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td><em>ifNull($null, 1)<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td><em>ifNull([Column], 0)<\/em><\/td>\n<td>Returns 0 if the value of the numeric field <strong>Column<\/strong> is null, and otherwise the value of <strong>Column<\/strong>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Conversion<\/h3>\n<p>Conversion functions allow you to change the type of a field. This process is usually delicate, especially when there are decimals, punctuation marks or special formats. It is advisable to test and validate that everything works correctly when using these functions.<\/p>\n<p><center>Functions<\/center><\/p>\n<table>\n<tbody>\n<tr>\n<td align=\"\">Number to text<\/td>\n<td align=\"\">Text to number<\/td>\n<\/tr>\n<tr>\n<td align=\"\">toString(n)<\/td>\n<td align=\"\">toNumber(t)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Number to text<\/h4>\n<p><em>Syntax: toString(number)<\/em><\/p>\n<p>Converts the number value to text. Integers are returned without decimal places, and numbers with decimal places are returned with a maximum of 5 decimal places. In addition, from 10 integer digits onwards the number is formatted as an exponential.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>toString(1)<\/em><\/td>\n<td><em>1<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>toString(3.1416)<\/em><\/td>\n<td><em>3.1416<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>toString(3.1415926535)<\/em><\/td>\n<td><em>3.14159<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>toString(123456789)<\/em><\/td>\n<td><em>123456789<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>toString(12345678901)<\/em><\/td>\n<td><em>1.23457e+10<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>toString([Column])<\/em><\/td>\n<td>Returns the numeric value of the <strong>Column<\/strong> field as text.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Text to number<\/h4>\n<p><em>Syntax: toNumber(text)<\/em><\/p>\n<p>Convert the string text to a number, whenever possible.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>toNumber(&#8220;&#8221;1&#8243;&#8221;)<\/em><\/td>\n<td><em>1.00<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>toNumber(&#8220;&#8221;3.1416&#8243;&#8221;)<\/em><\/td>\n<td><em>3.1416<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>toNumber(&#8220;&#8221;3a&#8221;&#8221;)<\/em><\/td>\n<td>null<\/td>\n<\/tr>\n<tr>\n<td><em>toNumber([Column])<\/em><\/td>\n<td>Returns, if possible, the numeric value of the <strong>Column<\/strong> text field, otherwise the null value.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Dates (parts)<\/h3>\n<p>These functions allow you to create, transform or convert fields of a temporary nature.<\/p>\n<p><strong>Functions<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td align=\"\">Year<\/td>\n<td align=\"\">Month<\/td>\n<td align=\"\">Name of the month<\/td>\n<td align=\"\">Day of the Month<\/td>\n<td align=\"\">Name of the day<\/td>\n<td align=\"\">Quarter<\/td>\n<\/tr>\n<tr>\n<td align=\"\">year(d[,b])<\/td>\n<td align=\"\">month(d[,b])<\/td>\n<td align=\"\">monthName(d[,l])<\/td>\n<td align=\"\">day(d[,b])<\/td>\n<td align=\"\">dayName(d[,l])<\/td>\n<td align=\"\">quarter(d[,p])<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4>Year<\/h4>\n<p><em>Syntax: year(date [, boolean])<\/em><\/p>\n<p>The function extracts the year from the date value. If the boolean true is given as the second argument, the return of the function is numeric, while otherwise or when only the first argument is given, the return is of text type.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLe<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>year($now)<\/em><\/td>\n<td>20XY (text)<\/td>\n<\/tr>\n<tr>\n<td><em>year($now, true)<\/em><\/td>\n<td>20XY.00 (number)<\/td>\n<\/tr>\n<tr>\n<td><em>year(dateFromParts(2023,1,1))<\/em><\/td>\n<td>2023<\/td>\n<\/tr>\n<tr>\n<td><em>year(dateFromParts(2024,1,1), true)<\/em><\/td>\n<td>2024.00<\/td>\n<\/tr>\n<tr>\n<td><em>year([Column])<\/em><\/td>\n<td>Year (text) associated to each date in the <strong>Column<\/strong> field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Month<\/h4>\n<p><em>Syntax: month(date [, boolean])<\/em><\/p>\n<p>The function extracts the month from the date value. If the boolean true is given as the second argument the return of the function is numeric (1-12), while otherwise or when only the first argument is given the return is of text type (01-12).<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLe<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>month(dateFromParts(2023,7,1))<\/em><\/td>\n<td>07<\/td>\n<\/tr>\n<tr>\n<td><em>month(dateFromParts(2024,9,1), true)<\/em><\/td>\n<td>9.00<\/td>\n<\/tr>\n<tr>\n<td><em>month([Column])<\/em><\/td>\n<td>Month (01-12) associated to each date in the <strong>Column<\/strong> field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Name of the month<\/h4>\n<p><em>Syntax: monthName(date [, language])<\/em><\/p>\n<p>The function extracts the month from the date value and returns the month name (&#8220;&#8221;January&#8221;&#8221;, &#8220;&#8221;February&#8221;&#8221;, &#8230;). The language of the text is determined according to the following priority criteria: language in which the application is consumed (multilingual) if defined, default language of the application (multilingual) if no specific language is specified, default language of the user in Vision (non-multilingual application), default language of the browser where the application is consumed (non-multilingual).<\/p>\n<p>Optionally it receives a second parameter indicating the language used if this is to be set. To change the language, the parameter must be passed using the two-letter ISO code for the language (&#8220;&#8221;en&#8221;&#8221;, &#8220;&#8221;pt&#8221;&#8221;, &#8220;&#8221;es&#8221;&#8221;).<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLe<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>monthName(dateFromParts(2023,7,1))<\/em><\/td>\n<td>July<\/td>\n<\/tr>\n<tr>\n<td><em>monthName(dateFromParts(2024,9,1))<\/em><\/td>\n<td>September<\/td>\n<\/tr>\n<tr>\n<td><em>monthName(dateFromParts(2024,9,1), &#8220;&#8221;es&#8221;&#8221;)<\/em><\/td>\n<td>septiembre<\/td>\n<\/tr>\n<tr>\n<td><em>monthName(dateFromParts(2024,9,1), &#8220;&#8221;pt&#8221;&#8221;)<\/em><\/td>\n<td>setembro<\/td>\n<\/tr>\n<tr>\n<td><em>monthName([Column])<\/em><\/td>\n<td>Name of the month associated with each date in the <strong>Column<\/strong> field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Day of the month<\/h4>\n<p><em>Syntax: day(date [, boolean])<\/em><\/p>\n<p>The function extracts the day of the month from the date value. If the boolean true is given as the second argument the return of the function is numeric (1-31), while otherwise or when only the first argument is given the return is text (01-31).<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLe<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>day(dateFromParts(2023,7,1))<\/em><\/td>\n<td>01<\/td>\n<\/tr>\n<tr>\n<td><em>day(dateFromParts(2024,9,14), true)<\/em><\/td>\n<td>14.00<\/td>\n<\/tr>\n<tr>\n<td><em>day([Column])<\/em><\/td>\n<td>Day of the month (01-31) associated with each date in the <strong>Column<\/strong> field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Name of the day of the week<\/h4>\n<p><em>Syntax: dayName(date [, language])<\/em><\/p>\n<p>The function extracts the day of the week from the date value and returns its name (&#8220;Monday&#8221;, &#8220;Tuesday&#8221;, &#8230;). The language of the text is determined according to the following priority criteria: language in which the application is consumed (multilingual) if defined, default language of the application (multilingual) if no specific language is specified, default language of the user in Vision (non-multilingual application), default language of the browser where the application is consumed (non-multilingual).<\/p>\n<p>Optionally it receives a second parameter indicating the language used if this is to be set. To change the language, the parameter must be passed using the two-letter ISO code for the language (&#8220;en&#8221;, &#8220;pt&#8221;, &#8220;es&#8221;).<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLe<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>dayName(dateFromParts(2023,7,1))<\/em><\/td>\n<td>Saturday<\/td>\n<\/tr>\n<tr>\n<td><em>dayName(dateFromParts(2024,9,1))<\/em><\/td>\n<td>Sunday<\/td>\n<\/tr>\n<tr>\n<td><em>dayName(dateFromParts(2024,9,1), &#8220;&#8221;es&#8221;&#8221;)<\/em><\/td>\n<td>domingo<\/td>\n<\/tr>\n<tr>\n<td><em>dayName(dateFromParts(2024,9,2), &#8220;&#8221;pt&#8221;&#8221;)<\/em><\/td>\n<td>segunda-feira<\/td>\n<\/tr>\n<tr>\n<td><em>dayName([Column])<\/em><\/td>\n<td>Name of the day of the week associated with each date in the <strong>Column<\/strong> field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Quarter<\/h4>\n<p><em>Syntax: quarter(date [, prefix])<\/em><\/p>\n<p>The function extracts the quarter of the year from the date value (1-4), and returns it as text. Optionally it can receive a text in quotes as a second parameter, which will be used as a prefix.<\/p>\n<p>Examples:<\/p>\n<div class=\"pri_table_wrapper\">\n<table>\n<thead>\n<tr>\n<th><strong>example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>quarter(dateFromParts(2023,1,1))<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td><em>quarter(dateFromParts(2024,4,1), &#8220;T-&#8220;)<\/em><\/td>\n<td>T-2<\/td>\n<\/tr>\n<tr>\n<td><em>quarter(dateFromParts(2024,7,1))<\/em><\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<td><em>quarter(dateFromParts(2024,10,2), &#8220;Q&#8221;)<\/em><\/td>\n<td>Q4<\/td>\n<\/tr>\n<tr>\n<td><em>quarter([Column])<\/em><\/td>\n<td>Quarter of the year (1-4) associated with each date in the \u201c<em>Column<\/em>\u201d field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Dates (complete)<\/h3>\n<p>Estas funciones permiten crear, transformar o convertir campos de naturaleza temporal.<\/p>\n<p><strong>Functions:<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td align=\"\">Date to text<\/td>\n<td align=\"\">Date from text<\/td>\n<td align=\"\">Date by components<\/td>\n<\/tr>\n<tr>\n<td align=\"\">dateToString(d, f)<\/td>\n<td align=\"\">dateFromString(t)<\/td>\n<td align=\"\">dateFromParts(y[, m, d, h, m, s, ms])<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"fecha-a-texto\">Date to text<\/h4>\n<p><em>Syntax: dateToString(date, format)<\/em><\/p>\n<p>It converts the date to text in the specified format.<\/p>\n<p>Format options.<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>Option<\/strong><\/th>\n<th>Description<\/th>\n<th><strong>Values<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>%Y<\/td>\n<td>Year (4 digits)<\/td>\n<td>0000-9999<\/td>\n<\/tr>\n<tr>\n<td>%m<\/td>\n<td>Month (2 digits)<\/td>\n<td>01-12<\/td>\n<\/tr>\n<tr>\n<td>%d<\/td>\n<td>Day of the month (2 digits)<\/td>\n<td>01-31<\/td>\n<\/tr>\n<tr>\n<td>%H<\/td>\n<td>Time (2 digits)<\/td>\n<td>00-23<\/td>\n<\/tr>\n<tr>\n<td>%M<\/td>\n<td>Minutes (2 digits)<\/td>\n<td>00-59<\/td>\n<\/tr>\n<tr>\n<td>%S<\/td>\n<td>Seconds (2 digits)<\/td>\n<td>00-60<\/td>\n<\/tr>\n<tr>\n<td>%L<\/td>\n<td>Milliseconds (3 digits)<\/td>\n<td>000-999<\/td>\n<\/tr>\n<tr>\n<td>%j<\/td>\n<td>Day of the year (3 digits)<\/td>\n<td>001-366<\/td>\n<\/tr>\n<tr>\n<td>%u<\/td>\n<td>Day of the week (1-Monday, 7-Sunday)<\/td>\n<td>1-7<\/td>\n<\/tr>\n<tr>\n<td>%w<\/td>\n<td>Day of the week (1-Sunday, 7-Saturday)<\/td>\n<td>1-7<\/td>\n<\/tr>\n<tr>\n<td>%V<\/td>\n<td>Week of the year (2 digits)<\/td>\n<td>01-53<\/td>\n<\/tr>\n<tr>\n<td>%U<\/td>\n<td>Week of the year (2 digits)<\/td>\n<td>00-52<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>dateToString(dateFromParts(2023,1,1), &#8220;%Y&#8221;)<\/em><\/td>\n<td>2023<\/td>\n<\/tr>\n<tr>\n<td><em>dateToString(dateFromParts(2024,4,1,17,5,45,433), &#8220;%Y-%m-%d %H:%M:%S.%L&#8221;)<\/em><\/td>\n<td>2024-04-01 17:05:45.433<\/td>\n<\/tr>\n<tr>\n<td><em>dateToString(dateFromParts(2024,1,1), &#8220;%j from %Y&#8221;)<\/em><\/td>\n<td>001 from 2024<\/td>\n<\/tr>\n<tr>\n<td><em>dateToString(dateFromParts(2024,1,1), &#8220;%U or %V starting the year?&#8221;)<\/em><\/td>\n<td>01 or 00 starting the year?<\/td>\n<\/tr>\n<tr>\n<td><em>dateToString([Column]&#8221;%Y-%m-%d&#8221;)<\/em><\/td>\n<td>Text associated with each date in the \u201cColumn\u201d field in \u201cYYYY-MM-DD\u201d format.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"fecha-desde-texto\"><a class=\"anchor\" href=\"#fecha-desde-texto\" name=\"fecha-desde-texto\"><\/a><a id=\"dateFromString\"><\/a>Date from text<\/h4>\n<p><em>Syntax: dateFromString(text)<\/em><\/p>\n<p>Returns a date based on the value specified in the text string, which must be constructed using the format \u201cYYYY-MM-DD H24: MI:SS.sss.\u201d The year and month must be provided; the rest of the format is optional.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>dateFromString(&#8220;2024-03&#8221;)<\/em><\/td>\n<td><em>date<\/em>\u00a0&#8220;2024\/03\/01 00:00:00.000Z&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromString(&#8220;2024&#8221;)<\/em><\/td>\n<td><em>ERROR<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>dateFromString(&#8220;2024-03-28&#8221;)<\/em><\/td>\n<td><em>date<\/em>\u00a0&#8220;2024\/03\/28 00:00:00.000Z&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromString(&#8220;2024-03-28 19:50:25.128&#8221;)<\/em><\/td>\n<td><em>date<\/em>\u00a0&#8220;2024\/03\/28 19:50:25.128Z&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromString([ColumnText])<\/em><\/td>\n<td>Date associated with the value of the \u201cColumnText\u201d field, which must be formatted as \u201cYYYY-MM-DD H24: MI:SS.sss\u201d.<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromString(dateToString(dateFromParts(2024,1,1),&#8221;%Y-%m-%d&#8221;))<\/em><\/td>\n<td><em>date<\/em>\u00a0&#8220;2024\/01\/01 00:00:00.000Z&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromString(dateToString([ColumnDate]&#8221;%Y-%m-%d&#8221;))<\/em><\/td>\n<td>Date truncated to the day for each value in the \u201cColumnDate\u201d field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"fecha-por-componentes\"><a class=\"anchor\" href=\"#fecha-por-componentes\" name=\"fecha-por-componentes\"><\/a>Date by components<\/h4>\n<p><em>Syntax: dateFromParts(YYYY[, MM, DD, H24, MI, SS, sss])<\/em><\/p>\n<p>Returns a date composed of its parts: year, month, day, hour (24-hour format), minute, second, and millisecond. At least the year must be specified.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>dateFromParts(2024)<\/em><\/td>\n<td><em>date<\/em>\u00a0&#8220;2024\/01\/01 00:00:00.000Z&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromParts(2024, 3, 28)<\/em><\/td>\n<td><em>date<\/em>\u00a0&#8220;2024\/03\/28 00:00:00.000Z&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromParts(2024, 3, 28, 19, 50,25, 128)<\/em><\/td>\n<td><em>date<\/em>\u00a0&#8220;2024\/03\/28 19:50:25.128Z&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromParts(year([ColumnDate], true), month([ColumnDate], true), day([ColumnDate], true))<\/em><\/td>\n<td>Date constructed from the annual, monthly, and daily parts of the <em>Column<\/em> field.<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromParts(year($now, true), month($now, true), day($now, true))<\/em><\/td>\n<td>$now date truncated to the day, whose value is equal to the $today variable.<\/td>\n<\/tr>\n<tr>\n<td><em>dateFromParts([ColumnYear], [ColumnMonth], [ColumnDay])<\/em><\/td>\n<td>Date constructed from the year, month, and day indicated by the numeric fields <em>ColumnYear<\/em>, <em>ColumnMonth<\/em>, and <em>ColumnDay<\/em>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Logic<\/h3>\n<p>Logical functions perform a logical operation with their arguments, of type boolean. Their return is in turn of Boolean type (true\/false), so they are not used directly as the result of a formula, but as variables in other functions that require Booleans as variables.<\/p>\n<p><center>Functions<\/center><\/p>\n<table>\n<tbody>\n<tr>\n<td align=\"center\">Function &#8220;Or&#8221;<\/td>\n<td align=\"center\">Function &#8220;No&#8221;<\/td>\n<td align=\"center\">Function &#8220;And&#8221;<\/td>\n<\/tr>\n<tr>\n<td align=\"center\">or(b1, b2, &#8230;)<\/td>\n<td align=\"center\">not(b)<\/td>\n<td align=\"center\">and(b1, b2, &#8230;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Function &#8220;Or&#8221;<\/h4>\n<p><em>Syntax: or(boolean1, boolean2, &#8230;)<\/em><\/p>\n<p>Returns true if any of the arguments is true, and false otherwise.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>RESULT<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>or(true, false, false)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>or(false, false, false)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>or(eq(1,1), ne(1,2))<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>or(gt(1,1), ne(1,2))<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>or(gt(1,1), ne(1,1))<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>or(gt([Column], 10), lt([Column], 4))<\/em><\/td>\n<td>Returns true if the value of the <strong>Column<\/strong> field is greater than 10 or less than 4, and false otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Function &#8220;No&#8221;<\/h4>\n<p><em>Syntax<\/em><em>: not(boolean)<\/em><\/p>\n<p>It performs the &#8220;negation&#8221; operation: if the argument is true it returns false, and if false it returns true.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>RESULT<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>not(true)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>not(false)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>not(eq(1,2))<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>not(ne(1,2))<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>not(gt([Column], 10))<\/em><\/td>\n<td>Returns false if the value of the <strong>Column<\/strong> field is greater than 10, and true otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Function &#8220;And&#8221;<\/h4>\n<p><em>Syntax<\/em><em>: and(boolean1, boolean2, &#8230;)<\/em><\/p>\n<p>Returns true if all arguments are true, and false otherwise.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>RESULT<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>and(true, true, false)<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>and(true, true, true)<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>and(eq(1,1), ne(1,2))<\/em><\/td>\n<td><em>true<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>and(gt(1,1), ne(1,2))<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>and(gt(1,1), ne(1,1))<\/em><\/td>\n<td><em>false<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>and(gt([Column], 10), lt([Column], 4))<\/em><\/td>\n<td>Returns true if the value of the <strong>Column<\/strong> field is greater than 10 and less than 4, and false otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Mathematics (approximation)<\/h3>\n<p>These commonly used mathematical functions apply only to numeric values and return a number.Functions<\/p>\n<table class=\" alignleft\">\n<tbody>\n<tr>\n<td style=\"width: 7.42347%;\" align=\"center\">Upper integer<\/td>\n<td style=\"width: 7.29062%;\" align=\"center\">Lower integer<\/td>\n<td style=\"width: 5.74707%;\" align=\"center\">Integer<\/td>\n<td style=\"width: 9.27793%;\" align=\"center\">Rounding decimals<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 7.42347%;\" align=\"center\">ceil(n)<\/td>\n<td style=\"width: 7.29062%;\" align=\"center\">floor(n)<\/td>\n<td style=\"width: 5.74707%;\" align=\"center\">trunc(n)<\/td>\n<td style=\"width: 9.27793%;\" align=\"center\">round(n[,p])<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><\/h4>\n<h4><\/h4>\n<h4>Upper integer<\/h4>\n<p><em>Syntax<\/em><em>: ceil(number)<\/em><\/p>\n<p>Returns the smallest integer that is greater than or equal to the given number.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>Ejemplo<\/strong><\/th>\n<th><strong>RESULT<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>ceil(0.95)<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td><em>ceil(9.003)<\/em><\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td><em>ceil(-2.8)<\/em><\/td>\n<td>-2<\/td>\n<\/tr>\n<tr>\n<td><em>ceil(1.5)<\/em><\/td>\n<td>2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Lower integer<\/h4>\n<p><em>Syntax: floor(number)<\/em><\/p>\n<p>Devuelve el entero m\u00e1s grande que sea menor o igual al n\u00famero dado.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>Ejemplo<\/strong><\/th>\n<th><strong>RESULT<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>floor(0.95)<\/em><\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td><em>floor(9.003)<\/em><\/td>\n<td>9<\/td>\n<\/tr>\n<tr>\n<td><em>floor(-2.8)<\/em><\/td>\n<td>-3<\/td>\n<\/tr>\n<tr>\n<td><em>floor(1.5)<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Integer<\/h4>\n<p><em>Syntax<\/em><em>: trunc(number)<\/em><\/p>\n<p>Trunca el n\u00famero dado a su valor entero: el entero inferior si es positivo y el superior si es negativo.<\/p>\n<p>Ejemplos:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>Ejemplo<\/strong><\/th>\n<th><strong>RESULT<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>trunc(0.95)<\/em><\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td><em>trunc(9.003)<\/em><\/td>\n<td>9<\/td>\n<\/tr>\n<tr>\n<td><em>trunc(-2.8)<\/em><\/td>\n<td>-2<\/td>\n<\/tr>\n<tr>\n<td><em>trunc(1.5)<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Rounding decimals<\/h4>\n<p><em>Syntax<\/em><em>: round(number[, precision])<\/em><\/p>\n<p>Redondea\u00a0<em>number<\/em>\u00a0a la precisi\u00f3n (<em>accuracy<\/em>) decimal indicada, y si no se indica \u00e9sta expl\u00edcitamente se entiende como 0. Cuando redondea a valores enteros, el valor\u00a0<code>X.5<\/code>\u00a0lo redondea a\u00a0<code>X<\/code>\u00a0si\u00a0<code>X<\/code>\u00a0es par, y a\u00a0<code>X+1<\/code>\u00a0si\u00a0<code>X<\/code>\u00a0es impar, mientras que cuando se redondea a uno o m\u00e1s decimales, el valor\u00a0<code>X.Y5<\/code>\u00a0lo redondea siempre a\u00a0<code>X.Y<\/code>\u00a0(cuestiones de precisi\u00f3n en la representaci\u00f3n de los valores num\u00e9ricos decimales).<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>Ejemplo<\/strong><\/th>\n<th><strong>RESULT<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>round(0.95)<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td><em>round(9.003)<\/em><\/td>\n<td>9<\/td>\n<\/tr>\n<tr>\n<td><em>round(-2.8)<\/em><\/td>\n<td>-3<\/td>\n<\/tr>\n<tr>\n<td><em>round(1.5)<\/em><\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<td><em>round(2.5)<\/em><\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<td><em>round(0.957432, 3)<\/em><\/td>\n<td>0.957<\/td>\n<\/tr>\n<tr>\n<td><em>round(0.957432, 1)<\/em><\/td>\n<td>1.0<\/td>\n<\/tr>\n<tr>\n<td><em>round(0.857432, 1)<\/em><\/td>\n<td>0.9<\/td>\n<\/tr>\n<tr>\n<td><em>round(0.95, 1)<\/em><\/td>\n<td>0.9<\/td>\n<\/tr>\n<tr>\n<td><em>round(0.85, 1)<\/em><\/td>\n<td>0.8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Mathematics (general)<\/h3>\n<p>Commonly used mathematical functions, apply only to numeric values and return a number.<\/p>\n<p><strong>Functions:<\/strong><\/p>\n<table style=\"width: 100%; height: 82px;\">\n<tbody>\n<tr style=\"height: 41px;\">\n<td style=\"height: 41px;\" width=\"7%\">Square root<\/td>\n<td style=\"height: 41px;\" width=\"7%\">Absolute value<\/td>\n<\/tr>\n<tr style=\"height: 41px;\">\n<td style=\"height: 41px;\" width=\"7%\">sqrt(n)<\/td>\n<td style=\"height: 41px;\" width=\"7%\">abs(n)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><\/h4>\n<h4><\/h4>\n<p><strong>Square root<\/strong><\/p>\n<p><em>Syntax: sqrt(number)<\/em><\/p>\n<p>Calcula la ra\u00edz cuadrada de\u00a0<em>number<\/em>.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<td><strong>EXAMPLE<\/strong><\/td>\n<td><strong>RESULT<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>sqrt(0)<\/em><\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td><em>sqrt(2)<\/em><\/td>\n<td>1.414213&#8230;<\/td>\n<\/tr>\n<tr>\n<td><em>sqrt(4)<\/em><\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<td><em>sqrt(-2)<\/em><\/td>\n<td><em>ERROR<\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Absolute value<\/strong><\/p>\n<p><em>Syntax: abs(number)<\/em><\/p>\n<p>Devuelve el valor absoluto de\u00a0<em>number<\/em>.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<td><strong>EXAMPLE<\/strong><\/td>\n<td><strong>RESULT<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>abs(-1)<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td><em>abs(0)<\/em><\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td><em>abs(1)<\/em><\/td>\n<td>1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Mathematics (exponential and logarithms)<\/h3>\n<p>These mathematical functions allow you to obtain exponentials and logarithms.<\/p>\n<p><strong>Functions:<\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 38px;\">\n<tbody>\n<tr style=\"height: 19px;\">\n<td style=\"width: 10%; height: 19px;\">Exponential<\/td>\n<td style=\"width: 10%; height: 19px;\">Natural logarithm<\/td>\n<td style=\"width: 10%; height: 19px;\">Logarithm<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 10%; height: 19px;\">exp(n)<\/td>\n<td style=\"width: 10%; height: 19px;\">ln(n)<\/td>\n<td style=\"width: 10%; height: 19px;\">log(n)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Exponential<\/strong><\/p>\n<p><em>Syntax: exp(number)<\/em><\/p>\n<p>Raises the number <em>e<\/em> to the exponent <em>number<\/em>\u00a0(e<sup>number<\/sup>).<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th style=\"width: 45.5017%;\"><strong>example<\/strong><\/th>\n<th style=\"width: 35.5289%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 45.5017%;\"><em>exp(0)<\/em><\/td>\n<td style=\"width: 35.5289%;\">1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.5017%;\"><em>exp(1)<\/em><\/td>\n<td style=\"width: 35.5289%;\">2.718282&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.5017%;\"><em>exp(-1)<\/em><\/td>\n<td style=\"width: 35.5289%;\">0.367879&#8230;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Logarithm<\/h4>\n<p><em>Syntax: log(number, base)<\/em><\/p>\n<p>Calculates the Logarithm of number in the given base.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 82.524%;\">\n<thead>\n<tr>\n<th style=\"width: 45.5017%;\"><strong>example<\/strong><\/th>\n<th style=\"width: 35.5289%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 45.5017%;\"><em>log(2, 2)<\/em><\/td>\n<td style=\"width: 35.5289%;\">1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.5017%;\"><em>log(4, 2)<\/em><\/td>\n<td style=\"width: 35.5289%;\">2<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.5017%;\"><em>log(2, 10)<\/em><\/td>\n<td style=\"width: 35.5289%;\">0.301029&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.5017%;\"><em>log(-2, 10)<\/em><\/td>\n<td style=\"width: 35.5289%;\"><em>ERROR<\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Natural logarithm<\/h4>\n<p><em>Syntax: ln(number)<\/em><\/p>\n<p>Calculate the natural logarithm of number.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 82.8714%;\">\n<thead>\n<tr>\n<th style=\"width: 46.1073%;\"><strong>example<\/strong><\/th>\n<th style=\"width: 36.0727%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 46.1073%;\"><em>ln(1)<\/em><\/td>\n<td style=\"width: 36.0727%;\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 46.1073%;\"><em>ln(2.718282)<\/em><\/td>\n<td style=\"width: 36.0727%;\">1.000000&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 46.1073%;\"><em>ln(0.367879)<\/em><\/td>\n<td style=\"width: 36.0727%;\">-1.000001&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 46.1073%;\"><em>ln(-1)<\/em><\/td>\n<td style=\"width: 36.0727%;\"><em>ERROR<\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Operators<\/h3>\n<p>Operators apply only when they are placed between numbers. They do not have a function syntax with arguments, simply the operator goes in the middle of the 2 numbers or components.<\/p>\n<p>Functions<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 16.6667%;\">Sum<\/td>\n<td style=\"width: 16.6667%;\">Subtraction<\/td>\n<td style=\"width: 16.6667%;\">Multiplication<\/td>\n<td style=\"width: 16.6667%;\">Division<\/td>\n<td style=\"width: 16.6667%;\">Power<\/td>\n<td style=\"width: 16.6667%;\">Subtraction of division<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\">+<\/td>\n<td style=\"width: 16.6667%;\">&#8211;<\/td>\n<td style=\"width: 16.6667%;\">*<\/td>\n<td style=\"width: 16.6667%;\">\/<\/td>\n<td style=\"width: 16.6667%;\">^<\/td>\n<td style=\"width: 16.6667%;\">%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Sum (+)<\/strong><\/p>\n<p><em>Syntax: addend1 + addend2<\/em><\/p>\n<p>Calculates the sum of two numbers or of a number and a date. If one of the expressions is of type date the other expression is treated as the number of milliseconds to add to the date.<\/p>\n<p>The return type of the formula is numeric if the addends are numbers, or a date if one of the addends is of type date.<\/p>\n<p>Examples:<\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 67px;\">\n<tbody>\n<tr style=\"height: 19px;\">\n<td style=\"width: 50%; height: 19px;\"><strong>Example<\/strong><\/td>\n<td style=\"width: 50%; height: 19px;\"><strong>Result<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 50%; height: 19px;\"><em>7 + 3<\/em><\/td>\n<td style=\"width: 50%; height: 19px;\">10<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 50%; height: 19px;\"><em>dateFromParts(2023,1,1,10,50) + 60000<\/em><\/td>\n<td style=\"width: 50%; height: 19px;\"><em>date<\/em>\u00a02023-01-01 10:51:00.000Z<\/td>\n<\/tr>\n<tr style=\"height: 10px;\">\n<td style=\"width: 50%; height: 10px;\"><em>[ColumnA] + [ColumnB]<\/em><\/td>\n<td style=\"width: 50%; height: 10px;\">Returns the value of the <strong>ColumnA<\/strong> field plus the value of the <strong>ColumnB<\/strong> field, except when any of the values is null, which returns null.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Subtraction (-)<\/strong><\/p>\n<p><em>Syntax: minuend &#8211; subtrahend<\/em><\/p>\n<p>Calculates the subtraction of two numbers, of a date minus a number, or of two dates. When subtracting a number from a date the number is interpreted in milliseconds, and when subtracting 2 dates both are converted to milliseconds to proceed to a numerical subtraction.<\/p>\n<p>The return type of the formula is numeric if minuend and subtrahend are numbers, is a date if minuend is a date and subtrahend is a number, and a number equal to the difference in milliseconds if minuend and subtrahend are both dates.<\/p>\n<p>Examples:<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 50%;\"><strong>Example<\/strong><\/td>\n<td style=\"width: 50%;\"><strong>Result<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>7 \u2013 3<\/em><\/td>\n<td style=\"width: 50%;\">4<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>dateFromParts(2023,1,1,10,50) &#8211; 60000<\/em><\/td>\n<td style=\"width: 50%;\"><em>date<\/em>\u00a02023-01-01 10:49:00.000Z<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>dateFromParts(2023,1,1,10,50) &#8211; dateFromParts(2023,1,1,10,49)<\/em><\/td>\n<td style=\"width: 50%;\">60000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>[ColumnA] &#8211; [ColumnB]<\/em><\/td>\n<td style=\"width: 50%;\">Returns the value of the <strong>ColumnA<\/strong> field minus the value of the <strong>ColumnB<\/strong> field, except when either value is null, which returns null.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Multiplication (*)<\/strong><\/p>\n<p><em>Syntax: factor1 * factor2<\/em><\/p>\n<p>Calculates the multiplication of two numbers, returning a number.<\/p>\n<p>Examples:<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 50%;\"><strong>Example<\/strong><\/td>\n<td style=\"width: 50%;\"><strong>Result<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>7 * 3<\/em><\/td>\n<td style=\"width: 50%;\">21<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>1 * 0<\/em><\/td>\n<td style=\"width: 50%;\"><em>0<\/em><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>[ColumnA] * [ColumnB]<\/em><\/td>\n<td style=\"width: 50%;\">Returns the value of the <strong>ColumnA<\/strong> field multiplied by the value of the <strong>ColumnB<\/strong> field, except when either value is null, which returns null.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Division (\/)<\/strong><\/p>\n<p><em>Syntax: dividend \/ divisor<\/em><\/p>\n<p>Calculates the division of two numbers, returning a number. When divisor takes the value 0 the result is null, as well as when either dividend or divisor is null.<\/p>\n<p>Examples:<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 50%;\"><strong>Example<\/strong><\/td>\n<td style=\"width: 50%;\"><strong>Result<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>7 \/ 2<\/em><\/td>\n<td style=\"width: 50%;\">3.5<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>8 \/ 4<\/em><\/td>\n<td style=\"width: 50%;\">2<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>[ColumnA] \/ [ColumnB]<\/em><\/td>\n<td style=\"width: 50%;\">Returns the value of the <strong>ColumnA<\/strong> field divided by the value of the <strong>ColumnB<\/strong> field, except when either value is null or the value of <strong>ColumnB<\/strong> is 0, which returns null.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Power (^)<\/strong><\/p>\n<p><em>Syntax: base ^ power<\/em><\/p>\n<p>Raises the base number to the specified numeric power exponent, returning a <em>base<sup> power<\/sup> number<\/em>.<\/p>\n<p>Examples:<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 50%;\"><strong>Example<\/strong><\/td>\n<td style=\"width: 50%;\"><strong>Result<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>2 ^ 3<\/em><\/td>\n<td style=\"width: 50%;\">8<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>[ColBase] ^ 2<\/em><\/td>\n<td style=\"width: 50%;\">Returns a number whose value is the result of squaring the value of the <strong>ColBase<\/strong> field, or null if the value of <strong>ColBase<\/strong> is null.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\"><em>2 ^ [ColPower]<\/em><\/td>\n<td style=\"width: 50%;\">Returns a number whose value is the result of raising 2 to the value of the <strong>ColPower<\/strong> field, or null if the value of <strong>ColPower<\/strong> is null.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Subtraction of division (%)<\/strong><\/p>\n<p><em>Syntax: dividend % divisor<\/em><\/p>\n<p>Calculates the remainder of the division of two numbers, returning a number. When divisor takes the value 0 the result is null, as well as when either dividend or divisor is null.<\/p>\n<p>Examples:<\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 75px;\">\n<tbody>\n<tr style=\"height: 18px;\">\n<td style=\"width: 50%; height: 18px;\"><strong>Example<\/strong><\/td>\n<td style=\"width: 50%; height: 18px;\"><strong>Result<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 50%; height: 19px;\"><em>7 % 2<\/em><\/td>\n<td style=\"width: 50%; height: 19px;\">1<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 50%; height: 19px;\"><em>8 % 4<\/em><\/td>\n<td style=\"width: 50%; height: 19px;\">0<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 50%; height: 19px;\"><em>[ColumnA] % [ColumnB]<\/em><\/td>\n<td style=\"width: 50%; height: 19px;\">Returns the remainder of dividing the value of the <strong>ColumnA<\/strong> field by the value of the <strong>ColumnB<\/strong> field, except when either value is null or the value of <strong>ColumnB<\/strong> is 0, which returns null.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Text (general)<\/h3>\n<p>These functions allow the manipulation, transformation and conversion of text strings. They are as follows:<\/p>\n<p><strong>Functions<\/strong><\/p>\n<table style=\"width: 98.2787%;\">\n<tbody>\n<tr>\n<td style=\"width: 28.0088%;\" align=\"center\">String comparison<\/td>\n<td style=\"width: 25.2735%;\" align=\"center\">Concatenation<\/td>\n<td style=\"width: 17.6149%;\" align=\"center\">Length<\/td>\n<td style=\"width: 13.9497%;\" align=\"center\">Position<\/td>\n<td style=\"width: 13.9497%;\">Separate text<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 28.0088%;\" align=\"center\">strCaseCmp(t1, t2)<\/td>\n<td style=\"width: 25.2735%;\" align=\"center\"><span style=\"color: #808080;\">c<\/span>oncat(t1, t2, &#8230;)<\/td>\n<td style=\"width: 17.6149%;\" align=\"center\">strLen(t)<\/td>\n<td style=\"width: 13.9497%;\" align=\"center\">indexOf(t, s [, f, t])<\/td>\n<td style=\"width: 13.9497%;\">split(t, s)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"comparaci\u00f3n-de-cadenas\">String comparison<\/h4>\n<p><em>Syntax: strCaseCmp(text1, text2)<\/em><\/p>\n<p>Given two text arguments, an alphanumeric comparison is performed, ignoring capital letters. The return value is numeric:<\/p>\n<ul>\n<li>1 if <em>text1<\/em> is greater than <em>text2<\/em>.<\/li>\n<li>0 if both texts are equal.<\/li>\n<li>-1 if <em>text2<\/em> is greater than <em>text1<\/em>.<\/li>\n<\/ul>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>strCaseCmp(&#8220;hello&#8221;, &#8220;bye&#8221;)<\/em><\/td>\n<td>1 (&#8220;h&#8221; &gt; &#8220;b&#8221;)<\/td>\n<\/tr>\n<tr>\n<td><em>strCaseCmp(&#8220;hello&#8221;, &#8220;Hello&#8221;)<\/em><\/td>\n<td>0 (&#8220;h&#8221; = &#8220;H&#8221;)<\/td>\n<\/tr>\n<tr>\n<td><em>strCaseCmp(&#8220;bye&#8221;, &#8220;hello&#8221;)<\/em><\/td>\n<td>-1 (&#8220;b&#8221; &lt; &#8220;h&#8221;)<\/td>\n<\/tr>\n<tr>\n<td><em>strCaseCmp(&#8220;123&#8221;, &#8220;hello&#8221;)<\/em><\/td>\n<td>-1 (&#8220;1&#8221; &lt; &#8220;h&#8221;)<\/td>\n<\/tr>\n<tr>\n<td><em>strCaseCmp([Column1], [Column2])<\/em><\/td>\n<td>1 if the value of the <em>Column1<\/em> field is alphanumerically greater than that of the <em>Column2<\/em> field, 0 if they are equal, and -1 otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Concatenation<\/h4>\n<p><em>Syntax: <span style=\"color: #808080;\">c<\/span>oncat(text1, text2, &#8230;)<\/em><\/p>\n<p>Concatenates two or more text strings.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em><span style=\"color: #808080;\">c<\/span>oncat(&#8220;This&#8221;, &#8221; &#8220;, &#8220;text&#8221;, &#8221; &#8220;, &#8220;comes&#8221;, &#8221; &#8220;, &#8220;from&#8221;, &#8221; &#8220;, &#8220;a&#8221;, &#8221; &#8220;, &#8220;<span style=\"color: #808080;\">c<\/span>oncat&#8221;, &#8221; &#8220;, &#8220;function.&#8221;)<\/em><\/td>\n<td>&#8220;This text comes from a <span style=\"color: #808080;\">c<\/span>oncat function.&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em><span style=\"color: #808080;\">c<\/span>oncat(&#8220;prefix &#8211; &#8220;, [Column])<\/em><\/td>\n<td>Adds the text string &#8220;prefix &#8211; &#8221; to the <strong>Column<\/strong> field value, or returns null if the field value is null.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Length<\/h4>\n<p><em>Syntax: strLen(text)<\/em><\/p>\n<p>Returns the number of characters (strictly the number of <a href=\"http:\/\/www.unicode.org\/glossary\/#code_point\" target=\"_blank\" rel=\"noopener\">UTF-8 code points<\/a>) in the string text.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>strLen(&#8220;Hello&#8221;)<\/em><\/td>\n<td>5<\/td>\n<\/tr>\n<tr>\n<td><em>strLen(&#8220;Hello Jack&#8221;)<\/em><\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td><em>strLen(&#8220;#&lt;@^\u00a5\u00ae\u00be\u00d8\u00e6?????&#8221;)<\/em><\/td>\n<td>14<\/td>\n<\/tr>\n<tr>\n<td><em>strLen([Column])<\/em><\/td>\n<td>Returns the number of characters in the <strong>Column<\/strong> field value.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Position<\/h4>\n<p><em>Syntax: indexOf(text, string [, from, to])<\/em><\/p>\n<p>This function returns the position of the first string match in text, where the position starts with the value 0 and ends with the value L-1, where L is the number of characters in text (strLen(text)). In case of no match it returns the value -1.<\/p>\n<p>Optionally, you can narrow the search range, that is, search for a match only in the range [from, to] of characters of text, discarding any match outside that range.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 100%;\">\n<thead>\n<tr>\n<th style=\"width: 33.7634%;\"><strong>EXAMPLE<\/strong><\/th>\n<th style=\"width: 65.4839%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 33.7634%;\"><em>indexOf(&#8220;Hello&#8221;, &#8220;H&#8221;)<\/em><\/td>\n<td style=\"width: 65.4839%;\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.7634%;\"><em>indexOf(&#8220;hello&#8221;, &#8220;H&#8221;)<\/em><\/td>\n<td style=\"width: 65.4839%;\">-1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.7634%;\"><em>indexOf(&#8220;Hello world&#8221;, &#8220;world&#8221;)<\/em><\/td>\n<td style=\"width: 65.4839%;\">6<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.7634%;\"><em>indexOf(&#8220;Hello world&#8221;, &#8221; &#8220;)<\/em><\/td>\n<td style=\"width: 65.4839%;\">5<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.7634%;\"><em>indexOf(&#8220;Hello world&#8221;, &#8220;world&#8221;, 2)<\/em><\/td>\n<td style=\"width: 65.4839%;\">6<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.7634%;\"><em>indexOf(&#8220;Hello world&#8221;, &#8220;world&#8221;, 0, 6)<\/em><\/td>\n<td style=\"width: 65.4839%;\">-1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.7634%;\"><em>indexOf(&#8220;Hello world&#8221;, &#8220;world&#8221;, 7, strLen(&#8220;Hello world&#8221;)-1)<\/em><\/td>\n<td style=\"width: 65.4839%;\">6<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.7634%;\"><em>indexOf([Column], &#8220;p&#8221;)<\/em><\/td>\n<td style=\"width: 65.4839%;\">Returns the position of the first occurrence of the string &#8220;p&#8221; for each value in the Column field in case of a match, and -1 otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"separar-texto\">Separate text<\/h4>\n<p><em>Syntax: split(text, sep)<\/em><\/p>\n<p>It splits the <em>text<\/em> string using the <em>sep<\/em> separator and returns an array with as many elements as divisions are obtained.<\/p>\n<p>Examples:<\/p>\n<div class=\"pri_table_wrapper\">\n<table>\n<thead>\n<tr>\n<th><strong>Example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>split(&#8220;a,b,c&#8221;, &#8220;,&#8221;)<\/em><\/td>\n<td>[&#8220;a&#8221;,&#8221;b&#8221;,&#8221;c&#8221;]<\/td>\n<\/tr>\n<tr>\n<td><em>split(&#8220;a,b,c&#8221;, &#8220;.&#8221;)<\/em><\/td>\n<td>[&#8220;a,b,c&#8221;]<\/td>\n<\/tr>\n<tr>\n<td><em>split(&#8220;&#8221;, &#8220;.&#8221;)<\/em><\/td>\n<td>[&#8220;&#8221;]<\/td>\n<\/tr>\n<tr>\n<td><em>split(&#8220;hello world&#8221;, &#8220;l&#8221;)<\/em><\/td>\n<td>[&#8220;he&#8221;,&#8221;&#8221;,&#8221;o wor&#8221;,&#8221;d&#8221;]<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Text (change)<\/h3>\n<p>Estas funciones permiten la transformaci\u00f3n y conversi\u00f3n de de cadenas de texto. Son las siguientes:<\/p>\n<p><strong>Functions<\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 92.4681%; height: 38px;\">\n<tbody>\n<tr style=\"height: 19px;\">\n<td style=\"width: 12.5%; height: 19px;\"><strong>Uppercase<\/strong><\/td>\n<td style=\"width: 12.5%; height: 19px;\"><strong>Lowercase<\/strong><\/td>\n<td style=\"width: 12.5%; height: 19px;\"><strong>Trim<\/strong><\/td>\n<td style=\"width: 12.5%; height: 19px;\"><strong>Substring<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 12.5%; height: 19px;\">toUpper(t)<\/td>\n<td style=\"width: 12.5%; height: 19px;\">toLower(t)<\/td>\n<td style=\"width: 12.5%; height: 19px;\">trim(t, [s])<\/td>\n<td style=\"width: 12.5%; height: 19px;\">substr(t, f, l)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Uppercase<\/strong><\/p>\n<p><em>Syntax: toUpper(text)<\/em><\/p>\n<p>Converts all text letters to uppercase. Applies the conversion to ASCII characters only.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>Example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>toUpper(&#8220;Hello&#8221;)<\/em><\/td>\n<td>&#8220;HELLO&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>toUpper(&#8220;Exit, this WAY&#8221;)<\/em><\/td>\n<td>&#8220;EXIT, THIS WAY&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>toUpper([Column])<\/em><\/td>\n<td>Returns each value of the <strong>Column<\/strong> field converted to uppercase.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Lowercase<\/strong><\/p>\n<p><em>Syntax: toLower(text)<\/em><\/p>\n<p>Converts all text letters to lowercase. Applies the conversion to ASCII characters only.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>toLower(&#8220;Hello&#8221;)<\/em><\/td>\n<td>&#8220;hello&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>toLower(&#8220;Exit, this WAY&#8221;)<\/em><\/td>\n<td>&#8220;exit, this way&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>toLower([Column])<\/em><\/td>\n<td>Returns each value of the <strong>Column<\/strong> field converted to lowercase.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Trim<\/strong><\/p>\n<p><em>Syntax: trim(text, [string])<\/em><\/p>\n<p>Removes all &#8220;space&#8221; characters at the beginning and end of text. In case of passing a second argument string it removes all characters that are part of string.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>example<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>trim(&#8220;hello&#8221;)<\/em><\/td>\n<td>&#8220;hello&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>trim(&#8221; hello &#8220;)<\/em><\/td>\n<td>&#8220;hello&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>trim(&#8220;hello&#8221;, &#8220;h&#8221;)<\/em><\/td>\n<td>&#8220;ello&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>trim(&#8220;hello&#8221;, &#8220;ho&#8221;)<\/em><\/td>\n<td>&#8220;ell&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>trim(&#8220;hello&#8221;, &#8220;l&#8221;)<\/em><\/td>\n<td>&#8220;hello&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>trim(&#8220;hello&#8221;, &#8220;hl&#8221;)<\/em><\/td>\n<td>&#8220;ello&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>trim([Column])<\/em><\/td>\n<td>Returns the value associated with the <strong>Column<\/strong> field without spaces at the beginning and end of the string.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Substring<\/h4>\n<p><em>Syntax: substr(text, from, length)<\/em><\/p>\n<p>Gets the substring of text from the from position by taking length characters, taking into account that the positions start counting from 0.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>EXAMPLE<\/strong><\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>substr(&#8220;hello world&#8221;, 0, 4)<\/em><\/td>\n<td>&#8220;hell&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>substr(&#8220;hello world&#8221;, 0, 5)<\/em><\/td>\n<td>&#8220;hello&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>substr(&#8220;hello world&#8221;, 1, 4)<\/em><\/td>\n<td>&#8220;ello&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>substr(&#8220;hello world&#8221;, 1, 5)<\/em><\/td>\n<td>&#8220;ello &#8220;<\/td>\n<\/tr>\n<tr>\n<td><em>substr(&#8220;hello world&#8221;, 6, 2)<\/em><\/td>\n<td>&#8220;wo&#8221;<\/td>\n<\/tr>\n<tr>\n<td><em>substr([Column], 0, 5)<\/em><\/td>\n<td>Returns the first 5 characters of each value in the <strong>Column<\/strong> field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Trigonometric (general)<\/h3>\n<p>Trigonometric functions are mathematical functions specifically for use with angle-related measurements. They are as follows:<\/p>\n<p><strong>Functions:<\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 20%;\"><strong>Degrees to radians\u00a0<\/strong><\/td>\n<td style=\"width: 20%;\"><strong>Radians to degrees\u00a0<\/strong><\/td>\n<td style=\"width: 20%;\"><strong>Sine<\/strong><\/td>\n<td style=\"width: 20%;\"><strong>Cosine<\/strong><\/td>\n<td style=\"width: 20%;\"><strong>Tangent<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">degreesToRadians(n)<\/td>\n<td style=\"width: 20%;\">radiansToDegrees(n)<\/td>\n<td style=\"width: 20%;\">sin(n)<\/td>\n<td style=\"width: 20%;\">cos(n)<\/td>\n<td style=\"width: 20%;\">tan(n)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4><\/h4>\n<h4>Degrees to radians<\/h4>\n<p><em>Syntax: degreesToRadians(number)<\/em><\/p>\n<p>Makes the conversion from number degrees to radians:<code>1\u00b0 \u00d7 ?\/180 = 0.0174533... rad<\/code>.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 86.5345%;\">\n<thead>\n<tr>\n<th style=\"width: 25.5452%;\">EXAMPLES<\/th>\n<th style=\"width: 63.6412%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 25.5452%;\"><em>degreesToRadians(1)<\/em><\/td>\n<td style=\"width: 63.6412%;\">0.017453&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.5452%;\"><em>degreesToRadians(45)<\/em><\/td>\n<td style=\"width: 63.6412%;\">0.785398&#8230; (?\/4)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.5452%;\"><em>degreesToRadians(60)<\/em><\/td>\n<td style=\"width: 63.6412%;\">1.047198&#8230; (?\/3)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.5452%;\"><em>degreesToRadians(90)<\/em><\/td>\n<td style=\"width: 63.6412%;\">1.570796&#8230; (?\/2)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.5452%;\"><em>degreesToRadians(180)<\/em><\/td>\n<td style=\"width: 63.6412%;\">3.141593&#8230; (?)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.5452%;\"><em>degreesToRadians([Column])<\/em><\/td>\n<td style=\"width: 63.6412%;\">Interprets each value in the <strong>Column<\/strong> field as degrees and returns it as converted to radians.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Radians to degrees<\/h4>\n<p><em>Syntax: radiansToDegrees(number)<\/em><\/p>\n<p>Makes the conversion from number radians to degrees:<code>1 rad \u00d7 180\/? = 57.2958...\u00b0<\/code>.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 80.6802%;\">\n<thead>\n<tr>\n<th style=\"width: 25.4413%;\">EXAMPLES<\/th>\n<th style=\"width: 55.778%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 25.4413%;\"><em>radiansToDegrees(0.017453)<\/em><\/td>\n<td style=\"width: 55.778%;\">0.999983&#8230; (~1\u00b0)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.4413%;\"><em>radiansToDegrees(0.785398)<\/em><\/td>\n<td style=\"width: 55.778%;\">44.999991&#8230; (~45\u00b0)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.4413%;\"><em>radiansToDegrees(1.047198)<\/em><\/td>\n<td style=\"width: 55.778%;\">60.000026&#8230; (~60\u00b0)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.4413%;\"><em>radiansToDegrees(1.570796)<\/em><\/td>\n<td style=\"width: 55.778%;\">89.999981&#8230; (~90\u00b0)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.4413%;\"><em>radiansToDegrees(3.141593)<\/em><\/td>\n<td style=\"width: 55.778%;\">180.000020&#8230; (~180\u00b0)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25.4413%;\"><em>radiansToDegrees([Column])<\/em><\/td>\n<td style=\"width: 55.778%;\">Interprets each value in the <strong>Column<\/strong> field as radians and returns it as converted to degrees.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Sine<\/h4>\n<p><em>Syntax: sin(number)<\/em><\/p>\n<p>Obtains the sine of number, understanding the value in radians.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 88.9122%;\">\n<thead>\n<tr>\n<th style=\"width: 15.784%;\">EXAMPLES<\/th>\n<th style=\"width: 76.7771%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 15.784%;\"><em>sin(0.017453)<\/em><\/td>\n<td style=\"width: 76.7771%;\">0.017452&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.784%;\"><em>sin(0.785398)<\/em><\/td>\n<td style=\"width: 76.7771%;\">0.707107&#8230; (~?2\/2)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.784%;\"><em>sin(1.047198)<\/em><\/td>\n<td style=\"width: 76.7771%;\">0.866026&#8230; (~?3\/2)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.784%;\"><em>sin(1.570796)<\/em><\/td>\n<td style=\"width: 76.7771%;\">1.000000&#8230; (~1)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.784%;\"><em>sin(3.141593)<\/em><\/td>\n<td style=\"width: 76.7771%;\">0.000000&#8230; (~0)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.784%;\"><em>sin(90)<\/em><\/td>\n<td style=\"width: 76.7771%;\">0.893997&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.784%;\"><em>sin([Column])<\/em><\/td>\n<td style=\"width: 76.7771%;\">Interprets each value in the <strong>Column<\/strong> field as radians and returns it by applying the sine function.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Cosine<\/h4>\n<p><em>Syntax: cos(number)<\/em><\/p>\n<p>Obtains the cosine of number, understanding the value in radians.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 73.7275%; height: 152px;\">\n<thead>\n<tr style=\"height: 19px;\">\n<th style=\"width: 15.5763%; height: 19px;\">EXAMPLES<\/th>\n<th style=\"width: 57.217%; height: 19px;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr style=\"height: 19px;\">\n<td style=\"width: 15.5763%; height: 19px;\"><em>cos(0.017453)<\/em><\/td>\n<td style=\"width: 57.217%; height: 19px;\">0.999848&#8230;<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 15.5763%; height: 19px;\"><em>cos(0.785398)<\/em><\/td>\n<td style=\"width: 57.217%; height: 19px;\">0.707107&#8230; (~?2\/2)<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 15.5763%; height: 19px;\"><em>cos(1.047198)<\/em><\/td>\n<td style=\"width: 57.217%; height: 19px;\">0.500000&#8230; (~1\/2)<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 15.5763%; height: 19px;\"><em>cos(1.570796)<\/em><\/td>\n<td style=\"width: 57.217%; height: 19px;\">0.000000&#8230; (~0)<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 15.5763%; height: 19px;\"><em>cos(3.141593)<\/em><\/td>\n<td style=\"width: 57.217%; height: 19px;\">-1.000000&#8230; (~-1)<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 15.5763%; height: 19px;\"><em>cos(90)<\/em><\/td>\n<td style=\"width: 57.217%; height: 19px;\">-0.448074&#8230;<\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 15.5763%; height: 19px;\"><em>cos([Column])<\/em><\/td>\n<td style=\"width: 57.217%; height: 19px;\">Interprets each value in the <strong>Column<\/strong> field as radians and returns it by applying the cosine function.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Tangent<\/h4>\n<p><em>Syntax: tan(number)<\/em><\/p>\n<p>Obtains the tangent of number, understanding the value in radians.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 73.9353%;\">\n<thead>\n<tr>\n<th style=\"width: 15.4725%;\">EXAMPLES<\/th>\n<th style=\"width: 57.5286%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 15.4725%;\"><em>tan(0.017453)<\/em><\/td>\n<td style=\"width: 57.5286%;\">0.017455&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.4725%;\"><em>tan(0.785398)<\/em><\/td>\n<td style=\"width: 57.5286%;\">1.000000&#8230; (1)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.4725%;\"><em>tan(1.047198)<\/em><\/td>\n<td style=\"width: 57.5286%;\">1.732053&#8230; (~?3)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.4725%;\"><em>tan(1.570796)<\/em><\/td>\n<td style=\"width: 57.5286%;\">3,060,023.306953&#8230; (~?)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.4725%;\"><em>tan(3.141593)<\/em><\/td>\n<td style=\"width: 57.5286%;\">0.000000&#8230; (~0)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.4725%;\"><em>tan(90)<\/em><\/td>\n<td style=\"width: 57.5286%;\">-1.995200&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 15.4725%;\"><em>tan([Column])<\/em><\/td>\n<td style=\"width: 57.5286%;\">Interprets each value of the <strong>Column<\/strong> field as radians and returns it by applying the tangent function.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Trigonometric (arcsine)<\/h3>\n<p><strong>Functions:<\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 38px;\">\n<tbody>\n<tr style=\"height: 19px;\">\n<td style=\"width: 20%; height: 19px;\">Arcsine<\/td>\n<td style=\"width: 20%; height: 19px;\"><strong>Hyperbolic arcsine<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 19px;\">\n<td style=\"width: 20%; height: 19px;\">asin(n)<\/td>\n<td style=\"width: 20%; height: 19px;\">asinh(n)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><strong>Arcsine <\/strong><\/h4>\n<p><em>Syntax: asin(number)<\/em><\/p>\n<p>Gets the arcsine of number, provided that it is a number greater than or equal to -1 and less than or equal to 1.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 82.0389%;\">\n<thead>\n<tr>\n<th style=\"width: 13.3956%;\">EXAMPLES<\/th>\n<th style=\"width: 70.6125%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 13.3956%;\"><em>asin(-1)<\/em><\/td>\n<td style=\"width: 70.6125%;\">-1.570796&#8230; (-?\/2)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.3956%;\"><em>asin(-0.5)<\/em><\/td>\n<td style=\"width: 70.6125%;\">-0.523599&#8230; (~-?\/6)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.3956%;\"><em>asin(0)<\/em><\/td>\n<td style=\"width: 70.6125%;\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.3956%;\"><em>asin(0.866026)<\/em><\/td>\n<td style=\"width: 70.6125%;\">1.047199&#8230; (~?\/3)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.3956%;\"><em>asin(1)<\/em><\/td>\n<td style=\"width: 70.6125%;\">1.570796&#8230; (?\/2)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.3956%;\"><em>asin(7)<\/em><\/td>\n<td style=\"width: 70.6125%;\"><em>ERROR<\/em><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.3956%;\"><em>asin([Column])<\/em><\/td>\n<td style=\"width: 70.6125%;\">Gets the arcsine of each value in the <strong>Column<\/strong> field, and returns null if the value is less than -1 or greater than 1.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Hyperbolic Arcsine<\/h4>\n<p><em>Syntax: asinh(number)<\/em><\/p>\n<p>Obtains the hyperbolic arcsine of number.<\/p>\n<p>Examples:<\/p>\n<div class=\"pri_table_wrapper\">\n<table style=\"width: 100%;\">\n<thead>\n<tr>\n<th style=\"width: 23.7799%;\">EXAMPLES<\/th>\n<th style=\"width: 75.3894%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 23.7799%;\"><em>asinh(-3.626860)<\/em><\/td>\n<td style=\"width: 75.3894%;\">-2,000000&#8230; (~-2)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 23.7799%;\"><em>asinh(-2)<\/em><\/td>\n<td style=\"width: 75.3894%;\">-1.443635&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 23.7799%;\"><em>asinh(0)<\/em><\/td>\n<td style=\"width: 75.3894%;\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 23.7799%;\"><em>asinh(1)<\/em><\/td>\n<td style=\"width: 75.3894%;\">0.881374&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 23.7799%;\"><em>asinh(1.175201)<\/em><\/td>\n<td style=\"width: 75.3894%;\">1.000000&#8230; (~1)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 23.7799%;\"><em>asinh([Column])<\/em><\/td>\n<td style=\"width: 75.3894%;\">Gets the hyperbolic arcsine of each value in the <strong>Column<\/strong> field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Trigonometric (arccosine)<\/h3>\n<p><strong>Functions:<\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 20%;\"><strong>Arccosine<\/strong><\/td>\n<td style=\"width: 20%;\"><strong>Hyperbolic arccosine<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">acos(n)<\/td>\n<td style=\"width: 20%;\">acosh(n)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Arccosine<\/h4>\n<p><em>Syntax: acos(number)<\/em><\/p>\n<p>Gets the arccosine of number, provided that it is a number greater than or equal to -1 and less than or equal to 1.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 72.3771%;\">\n<thead>\n<tr>\n<th style=\"width: 13.188%;\">EXAMPLES<\/th>\n<th style=\"width: 58.2555%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 13.188%;\"><em>acos(-1)<\/em><\/td>\n<td style=\"width: 58.2555%;\">3.141593&#8230; (-?)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.188%;\"><em>acos(-0.5)<\/em><\/td>\n<td style=\"width: 58.2555%;\">2.094395&#8230; (2?\/3)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.188%;\"><em>acos(0)<\/em><\/td>\n<td style=\"width: 58.2555%;\">1.570796&#8230; (?\/2)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.188%;\"><em>acos(0.707107)<\/em><\/td>\n<td style=\"width: 58.2555%;\">0.785398&#8230; (~?\/4)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.188%;\"><em>acos(1)<\/em><\/td>\n<td style=\"width: 58.2555%;\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.188%;\"><em>acos(7)<\/em><\/td>\n<td style=\"width: 58.2555%;\"><em>ERROR<\/em><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.188%;\"><em>acos([Column])<\/em><\/td>\n<td style=\"width: 58.2555%;\">Gets the arccosine of each value in the <strong>Column<\/strong> field, and returns null if the value is less than -1 or greater than 1.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Hyperbolic Arccosine<\/h4>\n<p><em>Syntax: acosh(number)<\/em><\/p>\n<p>Obtains the hyperbolic arccosine of number, provided that it is a number greater than or equal to 1.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 69.3663%;\">\n<thead>\n<tr>\n<th style=\"width: 14.2264%;\">EXAMPLES<\/th>\n<th style=\"width: 54.2056%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 14.2264%;\"><em>acosh(0)<\/em><\/td>\n<td style=\"width: 54.2056%;\"><em>ERROR<\/em><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2264%;\"><em>acosh(1)<\/em><\/td>\n<td style=\"width: 54.2056%;\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2264%;\"><em>acosh(1.543081)<\/em><\/td>\n<td style=\"width: 54.2056%;\">1.000000&#8230; (~1)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2264%;\"><em>acosh(2)<\/em><\/td>\n<td style=\"width: 54.2056%;\">1.316958&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2264%;\"><em>acosh(3.762196)<\/em><\/td>\n<td style=\"width: 54.2056%;\">2.000000&#8230; (~2)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 14.2264%;\"><em>acosh([Column])<\/em><\/td>\n<td style=\"width: 54.2056%;\">Gets the hyperbolic arccosine of each value in the <strong>Column<\/strong> field, and returns null if the value is less than 1.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n<section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock kb_post_hidden_area '   itemprop=\"text\" ><h3>Trigonometric (arctangent)<\/h3>\n<p><strong>Functions:<\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 20%;\"><strong>Arctangent<\/strong><\/td>\n<td style=\"width: 20%;\"><strong>2-parameter Arctangent<\/strong><\/td>\n<td style=\"width: 20%;\"><strong>Hyperbolic arctangent<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">atan(n)<\/td>\n<td style=\"width: 20%;\">atan2(n1,n2)<\/td>\n<td style=\"width: 20%;\">atanh(n)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Arctangent<\/h4>\n<p><em>Syntax: atan(number)<\/em><\/p>\n<p>Gets the arctangent of number, returning a value in radians.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 72.0654%;\">\n<thead>\n<tr>\n<th style=\"width: 24.8183%;\">EXAMPLES<\/th>\n<th style=\"width: 46.4174%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 24.8183%;\"><em>atan(-1)<\/em><\/td>\n<td style=\"width: 46.4174%;\">-0.785398&#8230; (-?\/4)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.8183%;\"><em>atan(-0.577350)<\/em><\/td>\n<td style=\"width: 46.4174%;\">-0.523599&#8230; (~?\/6)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.8183%;\"><em>atan(0)<\/em><\/td>\n<td style=\"width: 46.4174%;\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.8183%;\"><em>atan(1)<\/em><\/td>\n<td style=\"width: 46.4174%;\">0.785398&#8230; (?\/4)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.8183%;\"><em>atan(1.732051)<\/em><\/td>\n<td style=\"width: 46.4174%;\">1.047198&#8230; (~?\/3)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.8183%;\"><em>atan(7)<\/em><\/td>\n<td style=\"width: 46.4174%;\">1.428899&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.8183%;\"><em>atan([Column])<\/em><\/td>\n<td style=\"width: 46.4174%;\">Gets the arctangent of each value in the <strong>Column<\/strong> field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>2-parameter Arctangent<\/h4>\n<p><em>Syntax: atan2(number1, number2)<\/em><\/p>\n<p>Obtains the arctangent of 2 parameters number1 and number2, that is, the arctangent of number1\/number2.<\/p>\n<p>Examples:<\/p>\n<table style=\"width: 70.715%;\">\n<thead>\n<tr>\n<th style=\"width: 22.2222%;\">EXAMPLES<\/th>\n<th style=\"width: 47.6636%;\"><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 22.2222%;\"><em>atan2(1,1)<\/em><\/td>\n<td style=\"width: 47.6636%;\">0.785398&#8230; (?\/4)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 22.2222%;\"><em>atan2(0,1)<\/em><\/td>\n<td style=\"width: 47.6636%;\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 22.2222%;\"><em>atan2(1,0)<\/em><\/td>\n<td style=\"width: 47.6636%;\">1.570796&#8230; (?\/2)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 22.2222%;\"><em>atan2(7,2)<\/em><\/td>\n<td style=\"width: 47.6636%;\">1.292497&#8230;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 22.2222%;\"><em>atan2(-1.732051,1)<\/em><\/td>\n<td style=\"width: 47.6636%;\">-1.047198&#8230; (~-?\/3)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 22.2222%;\"><em>atan2([Column1], [Column2])<\/em><\/td>\n<td style=\"width: 47.6636%;\">Gets the arctangent of each <strong>Column1\/Column2<\/strong> value, and returns null in case Column2 is equal to 0.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Hyperbolic Arctangent<\/h3>\n<p><em>Syntax: atanh(number)<\/em><\/p>\n<p>Obtains the hyperbolic arctangent of number, provided that it is a number greater than -1 and less than 1.<\/p>\n<p>Examples:<\/p>\n<table>\n<thead>\n<tr>\n<th>EXAMPLES<\/th>\n<th><strong>Result<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><em>atanh(-2)<\/em><\/td>\n<td><em>ERROR<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>atanh(-1)<\/em><\/td>\n<td><em>null<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>atanh(-0.999999)<\/em><\/td>\n<td>-7.254329&#8230;<\/td>\n<\/tr>\n<tr>\n<td><em>atanh(-0.964028)<\/em><\/td>\n<td>-2.000006&#8230; (~-2)<\/td>\n<\/tr>\n<tr>\n<td><em>atanh(0)<\/em><\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td><em>atanh(0.5)<\/em><\/td>\n<td>0.549306&#8230;<\/td>\n<\/tr>\n<tr>\n<td><em>atanh(0.761594)<\/em><\/td>\n<td>1.000000&#8230; (~1)<\/td>\n<\/tr>\n<tr>\n<td><em>atanh([Column])<\/em><\/td>\n<td>Gets the hyperbolic arctangent of each value in the <strong>Column<\/strong> field, and returns null if the value is less than or equal to -1 or greater than or equal to 1.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/section>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1972,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","tags":[],"post-type":[300],"categoria-vision":[724],"class_list":["post-33787","vision","type-vision","status-publish","format-standard","hentry","post-type-artigo","categoria-vision-consultations"],"_links":{"self":[{"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/vision\/33787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/vision"}],"about":[{"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/types\/vision"}],"author":[{"embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/users\/1972"}],"replies":[{"embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/comments?post=33787"}],"version-history":[{"count":0,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/vision\/33787\/revisions"}],"wp:attachment":[{"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/media?parent=33787"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/tags?post=33787"},{"taxonomy":"post-type","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/post-type?post=33787"},{"taxonomy":"categoria-vision","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/categoria-vision?post=33787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}