Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

Formula Variable Creation

What's on This Page:


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


About Formula Variable Creation

It’s easier to ask your respondents for their height and weight than to ask them to guess their BMIs (Body Mass Indexes). But if you’re at the end of your data collection and realize you forgot to add a math operation for BMI to your embedded data, is there still a way Qualtrics can calculate this variable for you?

Formulas are a type of custom variable that allow you to create formulas with your survey’s variables. Values assigned with a formula variable will be applied to both collected and future data, making it an alternative to embedded data in situations where you need a variable to be added retroactively. Once created, formula variables can be used in the Data and Weighting sections of the Data & Analysis tab and in the Results section of the Reports tab. They can also be exported with your dataset or be retrieved by API if you use Create Response Export, Get Response Export Progress, and Get Response Export File calls.

Need to make changes to an existing formula? See our Editing Custom Variables page.

Creating a Formula

  1. Go to the Data & Analysis tab.
    Create New Field option in Tools Dropdown in top-right corner of Data & Analysis tab
  2. Click Tools on the right side.
  3. Select Create New Field.
  4. Select Formula at the top.
    New Variable Name text box, Equation text box, and variable selectors
  5. Name your formula variable.
  6. Type out your equation in the box. The green checkmark to the left of the box will become a red warning sign if your equation doesn’t make sense.
    Qtip: Every formula starts off with x and y, but you can add new variables by typing new letters into the box, and remove variables by deleting the corresponding letter from the formula box.
  7. Set x and y equal to a question, survey metadata, or embedded data.
  8. When finished, click Create Variable.
Qtip: Formulas do not calculate until after a response is submitted. If you’re looking to display calculations to your respondents in the middle of a survey, check out our Math Operations page.

Using the Correct Syntax

A formula has to make sense before it can be added to your data. Here are some guidelines to follow to ensure your formulas aren’t plagued by red triangles:

  • ( x + y ) / 2 specifies that x and y must be added together before they are then divided by two.
  • Always remember to close parentheses. ( x + y ) will work, but x + y ) won’t.
  • Numbers, single-letter variables, and the symbols listed in the table below are compatible with formulas. However, combined letters, like xy, are not. Instead, use x * y.
  • Spacing has no impact on the effectiveness of a formula. x/(y^2) and x / ( y ^ 2 ) will work the same way.

Available Operations

Math Operation Symbol Example
Addition + x + y
Subtraction x – y
Multiplication * x * y
Division / x / y
Powers (x^2) ^ x ^ y
Absolute Values abs( ) abs(x)
Ceiling ceil( ) ceil(x)
Floor floor( ) floor(x)
Qtip: If you don’t feel like typing them in, you can access Absolute Value, Ceiling, and Floor from the function (fx) icon, as seen below.
Operator selector for absolute value, ceiling, or floor

Compatible Variables

Not all variables can be used in a formula. Compatible items must be set to accept numeric values (or be finite in nature) by using recode values to determine the numeric value assigned to each answer choice. This includes:

  • Any question with a multiple choice option
  • Questions set to numeric-only answers, such as sliders and constant sum questions
  • Text entry questions set to numeric validation
  • Embedded data set as number or number set types
  • Survey metadata for response type, progress, duration (in seconds), and finished status
Qtip: Looking to combine non-numeric variables? Check out our Bucketing Variable Creation and Manual Variable Creation features.
Qtip: Formula variables are not compatible with scoring or scoring categories.

FAQs