I also would like to know if I have to purchase the Advanced version for this. Thank you!
You do not need the advanced version to do this, but it's development tools will save you a lot of time and effort making it well worth the extra cost.
Calculation field or look up tables can take text based data and return numeric values:
Case ( YesNoField = "Yes" ; 1 ; YesNoField = "No" ; 0 )