Forum Discussion

SamanthaStanley's avatar
SamanthaStanley
Qrew Member
5 years ago

Formulas

I have a form that shows 3 questions where the answer options are all Yes/No. If the question is answered as "Yes" I want it to be counted as one error, and "No" is equal to no errors. I have a field for "Total # of Errors" and a field for the %. How would I create the formulas to show the total number of errors?​

------------------------------
Samantha Stanley
------------------------------
Formulas and functions

3 Replies

  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    I would probably do something like this:

    var number one = IF([question 1]="Yes",1,0);
var number two = IF([question 2]="Yes",1,0);
var number three = IF([question 3]="Yes",1,0);

$one + $two + $three​


    ------------------------------
    Blake Harrison
    [email protected]
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------