Hi This is a simplification (the select is more complex and involves many left join)
suma = tb_lotes.superficie.sum() rows = db(qry).select( ... ... (suma / tb_establecimientos.superficie) * 100, ... left=[...], groupby=... ) if return records (return rows), the calculated field is shown as ((SUM(lotes.superficie) / establecimientos.superficie) * 100.0) The question I have is how access to this field when iterate over rows: for r in rows: r.??? I used it once, but do not remember how. José -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.