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

Multiplying classification field value with numerical field value

Daniel's Avatar

Daniel

15 Oct, 2015 03:02 PM

Hi guys.

I am having some trouble with a calculation I’m trying to implement.

I would like my calculation field to multiply a classification field value with a numerical field value.

The calculation I am using is CHOICEVALUE($building_element) * $square_meterage

So lets say I survey a window and 25m² needs replacing. I will choose a Building Element (classification field) which has a label of ‘Window’ and value of ‘125’ and then enter ‘25’ in Square Meterage (numeric field) which should give me the result of $3,125

Is this the correct way to go about it?

Thank you.

  1. 1 Posted by Jason Sanford on 15 Oct, 2015 07:54 PM

    Jason Sanford's Avatar

    Hi Daniel

    I think something like the following might work.

    var values = CHOICEVALUES($building_element);
    var last_value = values[values.length - 1];

    SETRESULT(NUM(last_value) * NUM($square_meterage));

  2. 2 Posted by Daniel on 16 Oct, 2015 07:35 AM

    Daniel's Avatar

    Thanks Jason it works, you're a star!

  3. Alex Helms closed this discussion on 04 Nov, 2015 02:28 PM.

Comments are currently closed for this discussion. You can start a new one.

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