All, I have a form that requires an age field calculation (working correctly) and then another field that has a rate table based on the age of that prior field (not working correctly). Please help! This is the script I am currently using:
event.value = "";
var SPage=Number(this.getField("SpouseAge").valueAsString);
var rate=0
if (this.getField("SPCH1").value=="Spouse")
if (SPage<14) rate=120.000;
else if (SPage<=15) rate=130.670;
else if (SPage<=16) rate=134.750;
else if (SPage<=17) rate=138.820;
else if (SPage<=18) rate=143.220;
else if (SPage<=19) rate=147.610;
else if (SPage<=20) rate=152.160;
else if (SPage<=21) rate=156.86;
else if (SPage<=22) rate=156.86;
else if (SPage<=23) rate=156.86;
else if (SPage>=24) rate=156.86;
else if (SPage<=25) rate=157.49;
else if (SPage<=26) rate=160.63;
else if (SPage<=27) rate=164.39;
else if (SPage<=28) rate=170.51;
else if (SPage<=29) rate=175.53;
else if (SPage<=30) rate=178.04;
else if (SPage<=31) rate=181.80;
else if (SPage<=32) rate=185.57;
else if (SPage>=33) rate=187.92;
else if (SPage<=34) rate=190.43;
else if (SPage<=35) rate=191.69;
else if (SPage<=36) rate=192.94;
else if (SPage<=37) rate=194.20;
else if (SPage<=38) rate=195.45;
else if (SPage<=39) rate=197.96;
else if (SPage<=40) rate=200.47;
else if (SPage<=41) rate=204.24;
else if (SPage>=42) rate=207.84;
else if (SPage<=43) rate=212.86;
else if (SPage<=44) rate=219.14;
else if (SPage<=45) rate=226.51;
else if (SPage<=46) rate=235.30;
else if (SPage<=47) rate=245.18;
else if (SPage<=48) rate=256.47;
else if (SPage<=49) rate=267.61;
else if (SPage<=50) rate=280.16;
else if (SPage>=51) rate=292.55;
else if (SPage<=52) rate=306.20;
else if (SPage<=53) rate=320.00;
else if (SPage<=54) rate=334.90;
else if (SPage<=55) rate=349.80;
else if (SPage<=56) rate=365.96;
else if (SPage>=57) rate=382.27;
else if (SPage<=58) rate=399.69;
else if (SPage<=59) rate=408.31;
else if (SPage<=60) rate=425.73;
else if (SPage<=61) rate=440.78;
else if (SPage<=62) rate=450.67;
else if (SPage<=63) rate=463.06;
else if (SPage>=64) rate=470.59;
event.value=rate
I think it is my last event.value but not sure what is wrong with it.
2
Replies
AdChoices