Is there a way to convert text into numerical values? What I am trying to do is have several fields where the choices can either be yes, no or NA. I want each of these to assign a numerical value.
for example:
field one: yes = 30, n = 0, na = 30
field two: yes = 30, n = 0, na = 30
field three: yes = 40, n = 0, na = 40
Then I want a field at the end which gives the percentage ... so if field 1 was yes, field 2 was no and field 3 was yes the score would be 70%. Attached a mockup screenshot of what I mean. Thanks.
------------------------------
William
------------------------------