7 Replies Latest reply on Jul 14, 2016 9:41 AM by rustyb2343416

    Custom calc for returning a percentage for number of times 'Yes' is returned in other fields.



      I have a series of fields that require a yes, no, n/a answer from a drop down. Then I need to auto calculate the # of times 'Yes' is selected divided by the number of Yes's and No's (but excludes adding the na's into the denominator). Numerator=Countif("yes")/Denominator=Countif("yes" or "no").