Skip to Content
This question has been flagged
computed-fieldsodoov10
2 Replies
2331 Views
Avatar
Austin

Hi,

We have a computed field called x_monthsdue.  to calculate it, we do,  record['x_monthsdue'] = self.credit / self.x_monthly .

We wish to introduce a condition such that IF credit is greater than zero, then we compute  record['x_monthsdue'] = self.credit / self.x_monthly   ELSE the field x_monthdue will be represented as OK.


The field x_monthlydue is type float and read only.


Regards,

Michael

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

You can define a compute function for field x_monthsdue as below.

@api.depends('credit', 'x_monthly')
def _compute_x_monthsdue(self):
    for rec in self:
        if rec.credit > 0:
            rec.x_monthsdue = rec.credit / rec.x_monthly
        else:
            rec.x_monthsdue = 'OK'

Regards

Avatar
Discard
Avatar
Austin
Author Best Answer

Brilliant. Thank you. 

Avatar
Discard
Related Posts Replies Views Activity
Compute Fields Solved
computed-fields
Avatar
Avatar
2
Jul 24
782
Odoo computed field
computed-fields
Avatar
Avatar
1
Jan 24
619
Make stored compute filed recompute after changing it logic but not depedencies.
computed-fields
Avatar
Avatar
Avatar
2
Apr 24
2686
Loan management system
odoov10
Avatar
Avatar
Avatar
2
Oct 23
5036
Question about computed and default fields. In company_dependent context.
api property computed-fields odoov10
Avatar
Avatar
Avatar
Avatar
3
Oct 23
8517