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

Forum|Forum|2 years ago
February 10, 2023
返信数 1.
1422 ビュー

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

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

解決！

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)