Calculating a percentage value in the database

[mostwanted]

I'm trying to calculate a required percentage value for the entered figure but i am getting the wrong answer

Field('unitPrice', 'float', label=SPAN('Unit Price', _style="font-weight: bold;"), requires=IS_MATCH('[0-9]+', error_message=T('Enter Money in Proper Figures'))),
Field('markup', 'integer', label=SPAN('Markup', _style="font-weight: bold;"), requires=IS_NOT_EMPTY()),
Field('markupCalc', 'integer', compute=lambda r: (100.0/float(r['markup'])*float(r['unitPrice']))),
Field('markedupPrice', 'float', compute=lambda r: round(float(r['unitPrice'])+r['markupCalc'])),

On the code above I'm getting the markupCalc field wrong and it affects the markedUpPrice value. How can i correctly calculate a required percentage of a given value?

Mostwanted

[mostwanted]

I figured out where my problem was, I switched up the arrangement of figures in markedCalc:, I put the dividing value before the markup value as opposed to what i did initially which was bringing it before the markup value and it worked.

Field('markupCalc', 'integer', compute=lambda r: (float(r['markup'])/100*float(r['unitPrice']))),

[Ari Lion BR Sp]

Field('markupCalc', 'integer', compute=lambda r: (float(r['markup']/100.0)*float(r['unitPrice']))),

??

but why integer?

you will have no precision.....

[mostwanted]

hahahaha thanks for highlighting that! I initially copied & pasted this line and didnt get rid of some impurities.