Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

if then else script help

Avatar

10-10-2008

I am trying to have a decimal field called Management that can make the following calculations with two fields ManagerScore and EmployeeScore.



if ManagerScore = null then EmployeeScore *.40

else

(ManagerScore + EmployeeScore) *.40/2



I have tried every possible combination that I can think of in the calculate event using FormCalc or JavaScript and failed every single time. Please help!!!!

Replies

Avatar

10-10-2008

Mildred try this:



if (ManagerScore.rawValue == null) {

EmployeeScore.rawValue = EmployeeScore.rawValue*0.40;

} else {

EmployeeScore.rawValue = (EmployeeScore.rawValue*0.40)/2;

}