![]() If no expression is provided, all rows of the data set will be searched (equivalent to the expression, TRUE). select-row? - An optional Yes/No expression, evaluated for each row of the data set, that returns TRUE or FALSE indicating whether the row should be included ( TRUE) or excluded ( FALSE) in the search for the maximum value.column - Name of the column of the named data set in which to find the maximum value, as a literal Text value (quoted or unquoted) may not be an expression.dataset - Name of the table or slice (the "data set") to search as a literal Text value (quoted or unquoted) may not be an expression.To access columns outside the row being considered, such as when using MAXROW() from within a column constraint, app formula, initial value, or format rule, reference the external column using _THISROW: MAXROW("Events", "Date", ( =. Column references within the select-row? expression (such as, ) are to the row being considered as the data set is searched. MAXROW("Events", "Date", ( = )) produces the error, Unable to find column. To fix, quote the problem name: MAXROW(Events, "Date") Any data set name that matches an AppSheet or Excel function name may produce this problem. In this example, the column name, Date, has significance within the internals of AppSheet and causes confusion. MAXROW(Events, Date) produces the error, Expression could not be parsed due to exception: #VALUE!. MAXROW("MyTable", "SomeColumn", FALSE) : returns a blank value because the select-row? expression will always return FALSE, excluding all rows from the search. ![]() MAXROW("Events", "Date", ( < DATE("1/1/" & YEAR(TODAY())))) returns the row for the most recent event prior to this year. )) returns the row for the most recent preceding event. MAXROW("Sales", "Close Date", ( = "Madrid")) returns the row for the newest sale in Madrid. MAXROW("Students", "GPA", ( = "2018")) returns the row for the (one) student with the highest GPA of the class of 2018. MAXROW("MyTable", "_ROWNUMBER") returns the key value for the row in the MyTable data set that has the highest value in the _ROWNUMBER column (that is, which row was added last?). ![]() Equivalent to MAXROW("Products", "Discount", TRUE). MAXROW("Products", "Discount") returns the key value for the row in the Products data set that has the highest value in the Discount column (that is, which product has the greatest discount?). Returns the key of a row ( Ref value) in the data set that contains the maximum value found in the named column from among the rows selected by an expression, or from among all rows if an expression was not provided.
0 Comments
Leave a Reply. |