There are two problems:
1) order is reserved keyword.
2) decimal types are treated as string internally and there for
compute should be
db.order.tipgranted.compute=lambda r:
float(r['totalsale'])*float(r['tipvalue'])
or better
db.order.tipgranted.compute=lambda r:
decimal.Decimal(r['totalsale'])*decimal.Decimal(r['tipvalue'])
On May 8, 10:00 pm, greenpoise <danel.sega...@gmail.com> wrote:
> Model:
>
> db.define_table('order',
> Field('employee',db.person),
> Field('tablenumber'),
> Field('ordernumber'),
> Field('orderdate','date'),
> Field('totalsale', 'decimal(10,2)'),
> Field('tipgranted', 'decimal(10,2)',default=None, update=None,
> readable=False),
> Field('tipvalue','decimal(10,2)',default='0.15'),)
>
> @auth.requires_login()
> def show_orders():
> db.order.tipgranted.compute=lambda r:
> r['totalsale']*r['tipvalue']
> form=crud.create(db.order)
>
> orders=db(db.order.employee==employee.id).select(orderby=db.order.ordernumber)
> return dict(employee=employee,orders=orders,form=form)
>
> thanks
>
> On May 8, 10:54 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > Can you show us the model and the action that triggers this?
>
> > On May 8, 9:49 pm, greenpoise <danel.sega...@gmail.com> wrote:
>
> > > Can someone help me. I am trying to do a simple calculation of fields.
> > > Fields are defined as decimal in db.py and here is the calculation:
>
> > > db.order.tipgranted.compute=lambda r: r['totalsale']*r['tipvalue']
>
> > > error: TypeError: can't multiply sequence by non-int of type 'float'
>
>
