Calculation: If this and this are true, then 'YES'; else 'NO'

2 replies
743 views
Translate

I would like to create a YES or NO answer in a text field using 2 conditions.

if 'TotalFamSize' = 1

and

the value of 'TotalFam6MoInc' <= the value of 'Six-Month Inc1'

then

'Level1Met' value is "YES"

else value is "NO"

Thanks for any help you can share.

This topic is closed to new replies. Start a new post to keep the conversation going.

try67Correct answer

Community Expert

As the custom calculation script of Level1Met enter this code:

if (this.getField("TotalFamSize").valueAsString=="1" && (Number(this.getField("TotalFam6MoInc").valueAsString) <= Number(this.getField("Six-Month Inc1").valueAsString))) 
	event.value = "YES";
else event.value = "NO";

try67

Correct answer

Community Expert

As the custom calculation script of Level1Met enter this code:

if (this.getField("TotalFamSize").valueAsString=="1" && (Number(this.getField("TotalFam6MoInc").valueAsString) <= Number(this.getField("Six-Month Inc1").valueAsString))) 
	event.value = "YES";
else event.value = "NO";

Translate

hbloodAuthor

Participant

This worked perfectly. Thank you!

I can now use this for the additional 9 levels by changing the .valueAsString and the field references.

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.