I need to calculate a field based on calculated field of Age (based on birthdate)

[Nancy283408177mic]

I'm very new to Java and not sure how to go about creating this calculated field.  I think I need to use an array but not sure.  

Ultimately, I need this field to get the age from "CalculatedAge", look in a table, pull the rate needed and put into the formula:  event.value=((((this.getField("EEVLife").value/1000)*Rate)*12)/26)

Any suggestions?

[try67 · Accepted solution]

You can do it like this:

var age = Number(this.getField("CalculatedAge").valueAsString);
var rate = 0;
if (age<10) rate = 0.2;
else if (age<=25) rate = 0.25;
else if (age<=35) rate = 0.5; // etc.

event.value=((((this.getField("EEVLife").value/1000)*rate)*12)/26)

[Nancy283408177mic]

Thank you, going to try that now!!!!

[Nancy283408177mic]

this is what I tried and getting a syntax error:

What did I do wrong?

[Bernd Alheit]

Use " at begin and end of field name.

[Nancy283408177mic]

Thank you, I see that now.  YOu are awesome!  

[Nancy283408177mic]

Worked like a charm!   Thanks again.