# Enhancement - Webforms Likert Scale - Ability to substitute text values with numeric values and calculate

**URL:** <https://community.ethosce.com/t/enhancement-webforms-likert-scale-ability-to-substitute-text-values-with-numeric-values-and-calculate/2028>\
**Category:** Reports and Analytics\
**Tags:** reports, webform\
**Created:** [December 6, 2022, 6:51pm UTC](https://community.ethosce.com/t/enhancement-webforms-likert-scale-ability-to-substitute-text-values-with-numeric-values-and-calculate/2028 "2022-12-06T18:51:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![davekaye](https://sea1.discourse-cdn.com/flex015/user_avatar/community.ethosce.com/davekaye/32/566_2.png) [@davekaye](https://community.ethosce.com/u/davekaye)\
**Post date:** [December 6, 2022, 6:51pm UTC](https://community.ethosce.com/t/enhancement-webforms-likert-scale-ability-to-substitute-text-values-with-numeric-values-and-calculate/2028/1 "2022-12-06T18:51:40Z")

</div>

This request is to be able to substitute numeric values for text strings that are in likert scales

Present state - admin creates a scale with text attributes with the order of the values  
example  
1|Poor  
2|Fair  
3|Good  
4|Very Good  
5|Excellent

Desired state would be for admin to be create a scale that would show the text label but **could provide the option to populate numeric values** for statistical computation (weighted average, mode, counts of answers)  
1|Poor  
2|Fair  
3|Good  
4|Very Good  
5|Excellent

Excellent would populate a value of 5  
Very Good would populate a value of 4  
or alternatively, if an author wanted to set a range of 10, 9,8,7,6, the author could and these could appear in the downloadable or data or possibly (even better) as a calculated field…

---

<div class="post-metadata">

**Author:** ![ewolfe](https://sea1.discourse-cdn.com/flex015/user_avatar/community.ethosce.com/ewolfe/32/2_2.png) [@ewolfe](https://community.ethosce.com/u/ewolfe)\
**Post date:** [December 7, 2022, 1:24pm UTC](https://community.ethosce.com/t/enhancement-webforms-likert-scale-ability-to-substitute-text-values-with-numeric-values-and-calculate/2028/2 "2022-12-07T13:24:44Z")

</div>

This is already how the system works, you can populate any numeric value and it won’t affect the display order.

[See this post for information about seeing averages appearing in a calculated field.](https://community.ethosce.com/t/best-practices-for-ethosce-analytics-and-webform/454)

When downloading the way data you can configure the keys to be downloaded for calculations:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/ethosce/original/1X/ed1f97e37583413bb7a36ef90566131c5d253dc9.png)

Hope this helps!
