Hi all,
I have tried searching the forum and cannot find the answer,
How do i perform a calculation on a column from a datatable and set the variable equal to front end server code
i.e
self.text_box_1 = app_tables.<my_table_name>.search(“column_name”).mean()
Welcome to the Anvil Community Forum!
As you can see here, a table Search Iterator does not have SQL’s statistical functions (sum, mean, median, mode, …). After all, a Search Iterator returns table rows. What does it mean to total a series of non-numeric objects, such as table rows?
But you can code the functions you want, in Python, by iterating over the search results.