This site has been archived. Please visit for our new support documentation and contact information.

How to calculate field values type single choice

angeles's Avatar


25 Oct, 2016 05:30 PM


In a field type single choice I added the following values:
  Moon, 200
  Mars 340

Now I want to create a multiple Calculation field selected item number 50.

For example, if you select Moon 200x50 10,000 in the field return calculation

Thank you

  1. Support Staff 1 Posted by Alex Helms on 25 Oct, 2016 05:56 PM

    Alex Helms's Avatar

    Since you are using a single choice field and was to use it in a mathematical calculation you will need to leverage both the CHOICEVALUE() and NUM() expressions.

    Something like this should work in your calculation field.

    SETRESULT(NUM(CHOICEVALUE($choice_field)) * 50)


  2. 2 Posted by Angeles Ramos on 25 Oct, 2016 06:12 PM

    Angeles Ramos's Avatar

    Hello Alex

    Thank you very much, it works perfectly.


  3. Support Staff 3 Posted by Alex Helms on 25 Oct, 2016 06:20 PM

    Alex Helms's Avatar

    Great to hear!

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac