Select: Given a Data Master record, returns the value of one of the attributes of that record.First upper: Capitalizes the first character.Lower case: Converts the text to lowercase.Upper case: Converts the text to uppercase.The first space is the text, second is the starting position, third is the ending position. Substring: Extracts a piece of text from a text given two positions.Concat (Concatenate): Combines two texts into one single text.These functions return a text as a combination of other texts or other criteria. Min: Determines the smallest number value from within a data set.Max: Determines the greatest number value from within a data set.Average: Determines the average value of a data set.Sum: The sum of the values within a data set.Count (data count): Returns the number of instances of a value included in a data set.If the second text is not found in the first, it will return -1 Index of: Returns a number that is the position of the second text within the first.Count: Returns the number of characters in a text.Mod: Returns the remainder after dividing two numbers.Sqrt: Returns the square root of the number entered.Percentage: Returns the percentage of the first number relative to the second.Round: Rounds a number to the number of decimals specified in the second space.Absolute: Returns a negative value as positive.Average: Returns the average value of two numbers.Min: Returns the smaller of two numbers.Max: Returns the greater of two numbers.Division: Takes two numbers and returns the result of dividing the first by the second number.Multiply: Takes two numbers and returns the result of multiplying them.Minus: Takes two numbers and returns the result of subtracting the second from the first.Plus: Takes two numbers and returns the result of adding them.Numberįunctions in this group will return a number as a value. They’re organized in ‘Number’, ‘Text’, ‘Logic’ (meaning true/false) and ‘Data’. Functions in the expression builderįunctions are grouped by the type of value that they return. Now let’s get into the specifics of each of those sections. Both can be used in expressions especially with some special functions like ‘Filter’. Data Masters: lists the Data Masters and attributes of that prototype.Variables can be dragged to the expression and will use the current value of that variable at the moment the expression is evaluated. Variables: lists all the variables in the prototype.You can drag any element from the screen to the expression and, once in the expression, use different types of properties of that element as values in the expression. Screen: displays the contents of the current screen.For instance, one constant gives you the current size of the window at the moment the expression is evaluated. Constants: these are a set of calculated values that can be used in the expressions.For instance, an addition function can take to numbers and return the sum of both. Functions can manipulate different values or results of other functions to obtain a different value. Functions: drag from this list of functions to the area in the top to add it to your expression.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |