I would like to create a YES or NO answer in a text field using 2 conditions.
if 'TotalFamSize' = 1
the value of 'TotalFam6MoInc' <= the value of 'Six-Month Inc1'
'Level1Met' value is "YES"
else value is "NO"
Thanks for any help you can share.
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";
This worked perfectly. Thank you!
I can now use this for the additional 9 levels by changing the .valueAsString and the field references.