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
此问题已终结
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
11月 21
|
2704 | ||
|
0
7月 22
|
1735 | ||
|
0
5月 22
|
2209 | ||
|
1
4月 25
|
1253 | ||
|
1
12月 24
|
2728 |