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

Forum|Forum|3 years ago
February 10, 2023
1 reply
1422 views

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?

This topic has been closed for replies.

Correct answer try67

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)

try67

Correct answer

Community Expert

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)