Skip to main content
hblood
hblood
Participant
October 31, 2019
Answered

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

  • October 31, 2019
  • 1 reply
  • 727 views

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 has been closed for replies.
Correct answer try67

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

 

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
October 31, 2019

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
    hbloodAuthor
    Participant
    October 31, 2019

    This worked perfectly.  Thank you!

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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices