I have classic grid that contains a list of payments made on account. The grid is populated from the bizobj payments which is a child of the client.
I need the subtotal and the balance. Total amt - subtotal = balance The bizobj has addField('amt_rec') addField('fk_client') I now have to sum(amt_rec) where fk_client = somePkOfClient. VirtualFields = {"subtotal": self.getSubTotal} def getSubTotal(self): tempCur=self.getTempCursor() tempCur.execute("Select sum(amt_rec) as totalrec from payments where fk_client = %s" % client_pkid) return tempCur.Record.totalrec "subtotal" has the correct figure. Can I use "subtotal" in the next virtual field? def getBalance(self): return total - self.subtotal What is the correct way to handle this? -- John Fabiani _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/200905192216.57669.jfabi...@yolo.com