تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
1 الرد
3190 أدوات العرض

Hello

I want to create 5 fields of selection type: N1, N2, N3, N4 and N5. Each field must have 3 possible selections. "Yes", "No" and "Do not apply"

And I need to calculate in another field the percentage of "Yes" answers out of the total fields.

Is it possible with Odoo Studio?



Thanks


الصورة الرمزية
إهمال
أفضل إجابة

Hi,
The Selection fields can be directly created with the Odoo studio. Drag and drop 'Selection' from the Add > New fields selection and in the field properties popup add the required selection options - 'Yes', 'No', 'Do not apply'.

For the percentage calculation a Decimal(float) field can be used. We have to define a compute function for this float field. For that select the field, cllck on the 'More' option under the Properties tab. In the form view , you can see the options to provide Dependencies and Compute function.

In the dependencies provide the names of the 5 selection fields separated by comma. For example - x_studio_n1, x_studio_n2,x_studio_n3, x_studio_n4,x_studio_n5.
In the Compute field provide the code to calculate our percentage.

Sample Code:

for record in self:
  yes_count = 0
  if record.x_studio_n1 == 'Yes':
    yes_count += 1
  if record.x_studio_n2 == 'Yes':
    yes_count += 1
  if record.x_studio_n3 == 'Yes':
    yes_count += 1
  if record.x_studio_n4 == 'Yes':
    yes_count += 1
  if record.x_studio_n5 == 'Yes':
    yes_count += 1    
  record['x_studio_percentage'] = yes_count*100/5

Regards

الصورة الرمزية
إهمال
الكاتب

Thank you so much, I prove it and it works perfectly¡

المنشورات ذات الصلة الردود أدوات العرض النشاط
1
نوفمبر 21
2734
0
يوليو 22
1741
0
مايو 22
2210
1
أبريل 25
1279
1
ديسمبر 24
2764