• Global community
• Language:
• Deutsch
• English
• Español
• Français
• Português
• 日本語コミュニティ
Dedicated community for Japanese speakers
• 한국 커뮤니티
Dedicated community for Korean speakers
Exit Search
• I need to calculate a field based on calculated fi...

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

Community Beginner ,
Feb 10, 2023 Feb 10, 2023

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?

TOPICS
How to , JavaScript , PDF forms

Views

187

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Community Expert , Feb 10, 2023 Feb 10, 2023

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)``````

6 Replies 6
Community Expert ,
Feb 10, 2023 Feb 10, 2023

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)``````

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Feb 10, 2023 Feb 10, 2023

Copied

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

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Feb 10, 2023 Feb 10, 2023

Copied

this is what I tried and getting a syntax error:

What did I do wrong?

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Expert ,
Feb 10, 2023 Feb 10, 2023

Copied

Use " at begin and end of field name.

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Feb 10, 2023 Feb 10, 2023

Copied

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

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Feb 10, 2023 Feb 10, 2023

Copied

LATEST

Worked like a charm!   Thanks again.