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

[hblood]

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.

[try67 · Accepted solution]

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";

[hblood]

This worked perfectly.  Thank you!

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