![]() Base is defined as number of records in the base table that "contribute" to the value of the aggregating expression specified. The first argument is an aggregating expression, the second specifies a table.Įvaluates "base count" for the specified aggregating expression. Similar to List function with the following differences:Arguments are expected to be scalar variable references (or fields of compound variables) with compatible typesResulting field codes are constructed from respective argument variable namesfor a plain variable argument the variable name is usedfor a compound variable field the resulting field name is _ Field codes are automatically assigned to be sequential numbers ("1", "2", etc) All arguments must be scalar values of compatible types. This function can be used either in lists or in aggregated tables.Ĭonstructs a compound value ("vector") from with fields defined by arguments. In this case the list of table can be empty meaning that join paths are chosen by length only. Additionally shortest path preference strategy is activated in case anchor tables are not enough or cannot be used. This function can be used either in lists or in aggregated tables. It is similar to"via" request actionapplied to a particular expression. The first argument is any expression, other arguments specify tables in data source.Įvaluates an argument expression in the context where the specified list of anchor tables are used to resolve join path ambiguities. ))Ī uniform way to evaluate a numeric value for numeric/single variables.įor a single variable argument numeric(x) = score(x) In case of multi choice argument it is equivalent to ANY(FIELDMASK(x, c1, c2. In case of single/open scalar argument it is equivalent to IN(x, c1, c2. Other arguments are text constants.Ī shortcut filter function that can be applied both to open/single/multi choice variables. The first argument is either a text/categorical scalar or a boolean vector (multi). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |