Is that possibly because the default value of tipvalue is a string
'0.15'? Try use float 0.15 instead.
--
Iceberg
On May9, 11:00am, 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.ordernumb
> er)
> 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'
