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
Odoo is the world's easiest all-in-one management software.
 It includes hundreds of business apps:
- सीआरएम
- e-Commerce
- लेखांकन
- इन्वेंटरी
- PoS
- Project
- MRP
This question has been flagged
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/5Regards
Thank you so much, I prove it and it works perfectly¡
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
| 
            
                Create a consecutive field
            
            
                    Solved
            
         |  | 1 नव॰ 21  | 3138 | |
|  | 0 जुल॰ 22  | 2087 | ||
|  | 0 मई 22  | 2570 | ||
|  | 1 अप्रैल 25  | 1993 | ||
| 
            
                Restrict Studio ,to users
            
            
                    Solved
            
         |  | 1 दिस॰ 24  | 3380 | 
