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.

Reply via email to