Copy link to clipboard
Copied
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?
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)
Copy link to clipboard
Copied
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)
Copy link to clipboard
Copied
Thank you, going to try that now!!!!
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Use " at begin and end of field name.
Copy link to clipboard
Copied
Thank you, I see that now. YOu are awesome!
Copy link to clipboard
Copied
Worked like a charm! Thanks again.