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

How to calculate field values type single choice

angeles's Avatar

angeles

25 Oct, 2016 05:30 PM

Hello,

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)
    

    Thanks,
    Alex

  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.

    Angeles

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

    Alex Helms's Avatar

    Great to hear!

Keyboard shortcuts

Generic

? 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