Skip to Content
This question has been flagged
computed-fieldsOdooStudioodooservererrorbillofmaterials
1 Respondre
1527 Vistes
Avatar
Aboubakar Siddiki

Good evening

I created a calculated field with Odoo Studio on the 'Bill of Materials' model in order to divide the quantity to be produced (base field) by the product density (associated field).

but every time after execution I end up with errors and I don't understand where this problem comes from

Here is the code I am using:


for record in self :

                record.x_studio_cv =   record.product_qty / record.x_studio_density


Thank you in advance for your help


Avatar
Descartar
Avatar
J.A. Daniel Göppner
Best Answer

Hi Abou bakkar 

try

for record in self :
result = 0
if record.x_studio_density !=0:
	​result = record.product_qty / record.x_studio_density
record.x_studio_cv =  result 

or 


for record in self:
    record.x_studio_cv = record.product_qty / record.x_studio_density if record.x_studio_density else 0




This prevent error dividing by 0 if some records has no density


Hope this help you

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Odoo Studio Computed Field Tax Amount in Sales Order Line
computed-fields OdooStudio
Avatar
0
de jul. 24
1576
ValueError: forbidden opcode(s) in 'lambda': STORE_ATTR
computed-fields
Avatar
Avatar
1
de juny 25
16942
Make stored compute filed recompute after changing it logic but not depedencies.
computed-fields
Avatar
Avatar
Avatar
Avatar
3
d’abr. 25
7542
Compute Fields Solved
computed-fields
Avatar
Avatar
2
de jul. 24
9325
Report or view to show discounts given as a result of coupons used on ecommerce
OdooStudio
Avatar
0
de jul. 24
1777