Calculations from other calculation fields
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?
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
Please sign in to leave a comment.