Calculations from other calculation fields

Follow

Hannah Durrant

• June 01, 2017 13:32

Hello, 

I am trying to put together a H&S Risk Assessment app for our projects. 

I've currently got field in a webform for project managers to select the ''Likelihood' and 'Consequence' of identified Risks. These are category fields for them to choose from.

I've then used a calculation field to assign a value based on the selection they choose to give a score for 'Likelihood' and then another calculation field to give a score for 'Consequence'

I wanted to do a simple calculation in another field to show Likelihood Score * Consequence Score

But I keep getting an error saying it's not a valid number. 

I've read other topics on this and believe this is because the calculation fields are showing no value. But I don't know how to get around this.

Any ideas anyone?

0

• 

  Rainer Grabowski

  • June 03, 2017 10:29
  • Edited

  Hi Hannah,

  if the fields Likelihood Score and Consequence Score are real number fields and show nothing but a number you have to assign the value (number) 0 if the fields ary empty. You can try this (read as: field value OR 0; || = OR)

  var l = @Likelihood Score || 0;
  var c = @Consequence Score || 0;
  l * c

  Rainer
  rg@delos-consulting.com

  0

  Comment actions Permalink

Please sign in to leave a comment.