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:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- 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/5
Regards
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 upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
Create a consecutive field
Solved
|
|
1
Nov 21
|
1755 | |
|
0
Jul 22
|
952 | ||
|
0
May 22
|
1221 | ||
Restrict Studio ,to users
Solved
|
|
1
Nov 24
|
873 | |
|
1
Mar 24
|
1098 |