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

Calculation Expressions and "Other" Values in Classification Sets

Adam C's Avatar

Adam C

26 Oct, 2016 12:14 AM

Hi there,

I'm having trouble using a calculation to display a value in a classification set that was inputted as "other".

For example: in the following classification set titled $taxonomy I have the following options.
Order > Family > Genus > Species

I would like the calculation field to only show the value of the 'Species' subset, which contains three choices with their respective values as 'Cat', 'Dog' and 'Human'.

The expression I'm using in the calculation field looks like:

if ($taxonomy && $taxonomy.choice_values[3]) {
SETRESULT($taxonomy.choice_values[3]); }

If 'Cat', 'Dog' or 'Human' are selected, the value displays in the calculation field (great) just as expected.

However, if I have manually inputted a value for choice_values3 by pressing 'Other' and typing in "Snake" rather than selecting 'Dog', 'Cat' or 'Human', nothing displays in the calculation field.

Any insight on how to resolve this?

  1. 1 Posted by Bryan McBride on 26 Oct, 2016 01:43 PM

    Bryan McBride's Avatar

    The CHOICEVALUE() function will return the selected value for both listed and "other" values.

  2. 2 Posted by Adam C on 26 Oct, 2016 05:53 PM

    Adam C's Avatar

    You're awesome. Thanks, Bryan.

  3. 3 Posted by Bryan McBride on 26 Oct, 2016 06:35 PM

    Bryan McBride's Avatar

    Happy to help!

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