Calculations Tab

Go to Options|Data Defaults, Calculations tab to change defaults for how special codes responses are treated in calculations.

Treat as Zero: Select this choice if you generally want to substitute a value of zero for a Don’t Know, Refused, or Not Applicable response when performing an interim calculation. This choice can be overridden for individual Data Elements.

Treat as Allowable range: Select this choice if you generally do not want to substitute any value for a Don’t Know, Refused, or Not Applicable response when performing an interim calculation. This choice can be overridden for individual Data Elements.

Treat as Limited range: Select this choice if you want to substitute a specified value or limited range for Don't Know, Refused, or Not Applicable response when performing an interim calculation. The specified range is entered in the box to the right. To specify an exact value, enter that value in both the From and To boxes.

Ranges for responses are listed in Skip-Edit Check Reports and in response data in the Preview Tool. See Special Code Values in Automatic Variable Calculations and Using Special Codes in QDS Expressions for more information.