{"id":12081,"date":"2026-05-28T15:20:14","date_gmt":"2026-05-28T15:20:14","guid":{"rendered":"https:\/\/nwvbjzy.cluster100.hosting.ovh.net\/?post_type=docs&#038;p=12081"},"modified":"2026-06-01T16:11:24","modified_gmt":"2026-06-01T16:11:24","password":"","slug":"questions_calculees","status":"publish","type":"docs","link":"https:\/\/www.soft-concept.com\/en\/documentation\/questions_calculees\/","title":{"rendered":"Calculated questions"},"content":{"rendered":"<p>The calculated question is the result of a calculation formula that will return a numeric or empty value.<\/p>\n<p>The calculated variables are primarily used:<\/p>\n<ul>\n<li>To show the respondent a result calculated from their answers (score, grade obtained, loan conditions, etc.).<\/li>\n<li>To summarize a complex condition of navigation in the questionnaire (page breaks, conditional display of page, hiding of area or inter-question control) with a simple value of 0 or 1.<\/li>\n<li>To implement customized consistency checks.<\/li>\n<li>To store in the data file a result that we do not want to have to recalculate during the analysis.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #052142;\">1- Operating principle<\/span><\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/www.soft-concept.com\/wp-content\/uploads\/2026\/05\/principe-de-fonctionnement.png\" alt=\"Principe de fonctionnement\" \/><\/p>\n<h3><span style=\"color: #f58900;\">1.1- Behavior of calculated questions<\/span><\/h3>\n<p>La formule d&rsquo;une question calcul\u00e9e se d\u00e9finit dans le bloc <strong><em>Formula<\/em><\/strong> of its properties.<\/p>\n<p>By default:<\/p>\n<ul>\n<li>She is <strong>masked<\/strong> for the respondent.<\/li>\n<li>Its result is <strong>calculated automatically<\/strong> at each page change, regardless of where the question is located in the questionnaire.<\/li>\n<\/ul>\n<h3><span style=\"color: #f58900;\">1.2- Displaying the result in the questionnaire<\/span><\/h3>\n<p>To display the question, you will need to go to the tab <strong><em>presentation<\/em><\/strong> properties of the question, then check the box <strong><em>see in the form<\/em><\/strong>.<\/p>\n<p>Par d\u00e9faut, le r\u00e9sultat est affich\u00e9 sous forme d&rsquo;entier.<\/p>\n<p>If the result of your calculation may contain decimals, you can define the number of digits after the decimal point directly below the block <strong><em>Formula<\/em><\/strong> in the properties of the question.<\/p>\n<h3><span style=\"color: #f58900;\">1.3- Display the result on the same page<\/span><\/h3>\n<p>If you want the result to be calculated on the same page as the questions that make it up, two conditions are necessary:<\/p>\n<ul>\n<li>Place the calculated question on this same page.<\/li>\n<li>Add the questions used in the formula, in the block <strong><em>Calculation on demand<\/em><\/strong> properties of the calculated question.<\/li>\n<\/ul>\n<p>Ainsi, d\u00e8s qu&rsquo;un r\u00e9pondant modifie une de ces questions, le r\u00e9sultat se met \u00e0 jour automatiquement, sans attendre le changement de page.<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #052142;\">2- The elements that can be used in a formula<\/span><\/h2>\n<h3><span style=\"color: #f58900;\">2.1- The value of a question<\/span><\/h3>\n<p>The reference <strong>Vn<\/strong> corresponds to the value of a question where <strong>n<\/strong> is the question number.<\/p>\n<p><em><u>Ex<\/u> : V2 is the value from question 2.<\/em><\/p>\n<p>The value of the question will have a different meaning depending on the type of question:<\/p>\n<ul>\n<li><strong>Numerical or calculated<\/strong>: Vn corresponds to the numerical value.<\/li>\n<li><strong>Qualitative single-choice options<\/strong> : Vn is the order number of the chosen answer.<\/li>\n<li><strong>Qualitative multiple-choice<\/strong>: Vn is the number of responses.<\/li>\n<li><strong>Date<\/strong>: Vn corresponds to the conversion of a Date into the number of days between that date and 01\/01\/1900.<\/li>\n<li><strong>Hour<\/strong>: Vn corresponds to the value in seconds of one hour.<\/li>\n<li><strong>Text<\/strong>: Vn is <strong><u>not usable<\/u><\/strong>.<\/li>\n<\/ul>\n<h3><span style=\"color: #f58900;\">2.2 - The score of a question<\/span><\/h3>\n<p>The reference <strong>Sn<\/strong> corresponds to the score obtained by question n where <strong>n<\/strong> is the question number.<\/p>\n<p>The score for this question corresponds to the sum of the scores associated with each answer checked for question n.<\/p>\n<p>This score will be 0 if no answer is checked, or if the checked answers have no scores.<\/p>\n<h3><span style=\"color: #f58900;\">2.3- The operators:<\/span><\/h3>\n<h4>2.3.1- Mathematics<\/h4>\n<ul>\n<li>Addition (+)<\/li>\n<li>Subtraction (-)<\/li>\n<li>Multiplication (*)<\/li>\n<li>Division (\/)<\/li>\n<\/ul>\n<p><u>As a reminder<\/u>\u00a0Multiplication and division take precedence over addition and subtraction.<\/p>\n<h4>2.3.2- By comparison<\/h4>\n<ul>\n<li>Sup\u00e9rieur strict (&gt;)<\/li>\n<li>Sup\u00e9rieur ou \u00e9gale (&gt;=)<\/li>\n<li>Inf\u00e9rieur strict (&lt;)<\/li>\n<li>Inf\u00e9rieur ou \u00e9gale (&lt;=)<\/li>\n<li>Equal (=)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #052142;\">3- Logical functions<\/span><\/h2>\n<h3><span style=\"color: #f58900;\">3.1- SI<\/span><\/h3>\n<p>Allows you to condition a calculation. The condition will be formed by an operation or by other logical functions.<\/p>\n<p><strong>Syntax<\/strong> : IF(condition; value_if_true; value_if_false)<\/p>\n<p><em><u>Example<\/u><\/em> : <em>SI(V2&gt;0 ; V1\/V2 ; NR)<\/em>.<\/p>\n<p>If the answer to question 2 is strictly greater than 0, the result of the calculated question will be V1\/V2. Conversely, if the answer is less than or equal to 0, the calculated question will take the value NR, i.e., not answered.<\/p>\n<h3><span style=\"color: #f58900;\">3.2- AND<\/span><\/h3>\n<p>Each condition must be met for the AND() function to be &quot;true&quot;.<\/p>\n<p><em><u>Example<\/u><\/em> : SI(ET(V2&lt;0;V2&gt;0);V1\/V2;NR)<\/p>\n<p>Divides V1 by V2 only if V2 is not zero, otherwise returns a non-response (NR).<\/p>\n<h3><span style=\"color: #f58900;\">3.3- Or<\/span><\/h3>\n<p>The OR() function itself only needs to be &quot;true&quot; if at least one condition is met.<\/p>\n<p><em><u>Example<\/u><\/em> : SI(OU(V2&lt;0;V2&gt;0);NR;V1\/V2)<\/p>\n<p>Divides V1 by V2 only if V2 is not zero, otherwise returns a non-response (NR).<\/p>\n<h3><span style=\"color: #f58900;\">3.4- NR<\/span><\/h3>\n<p>NR is an action that returns the unanswered value to the calculated question, so we get an empty value.<\/p>\n<p>This is useful for avoiding errors such as division by zero.<\/p>\n<p><em><u>Example<\/u><\/em> : IF(V2=0;NR;V1\/V2)<\/p>\n<h3><span style=\"color: #f58900;\">3.5- No<\/span><\/h3>\n<p>NO is used to reverse a condition.<\/p>\n<p><em><u>Example<\/u><\/em> : IF(NOT(V2=0);V1\/V2;NR)<\/p>\n<p>Divides V1 by V2 only if V2 is not zero, otherwise returns a non-response (NR).<\/p>\n<h3><span style=\"color: #f58900;\">3.6- Answered<\/span><\/h3>\n<h4>3.6.1- ANSWERED(n)<\/h4>\n<p>The logical function ANSWERED(n) is used to check if the question number <strong>n<\/strong> is answered.<\/p>\n<p><em><u>Example<\/u><\/em>\u00a0: ANSWERED(1)<\/p>\n<p>If question 1 is answered, the calculation will take the value 1, otherwise it will take the value 0.<\/p>\n<h4>3.6.2- ANSWERED(Vn,x)<\/h4>\n<p>The logical function ANSWERED(Vn,x) is used to check if a question option has been answered. With <strong>n<\/strong> which corresponds to the question number and, <strong>x<\/strong> to the modality.<\/p>\n<p><em><u>Example<\/u><\/em>\u00a0: IF(OR(ANSWERED(V1,1);ANSWERED(V2,1));1;0)<\/p>\n<p>The calculation returns 1 if the first option is selected in both questions.<\/p>\n<h4>3.6.3- RESPONDUREP(Vn,x)<\/h4>\n<p>The logical function REPANDREP(Vn,x) is used to check if multiple options of a question have been answered. With <strong>n<\/strong> which corresponds to the question number and, <strong>x<\/strong> to the modality.<\/p>\n<p><em><u>Example<\/u><\/em>\u00a0: RESPONSEP(V1,1) + RESPONSEP(V1,2) + RESPONSEP(V1,3)<\/p>\n<p>The calculation will examine the options in question 1 and will return:<\/p>\n<ul>\n<li>3 if all three options have been checked.<\/li>\n<li>2 if two of the options have been checked.<\/li>\n<li>1 if only one of the options has been checked.<\/li>\n<li>0 if none of the options have been checked.<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>La question calcul\u00e9e est le r\u00e9sultat d\u2019une formule de calcul qui renverra une valeur num\u00e9rique ou vide. Les variables calcul\u00e9es sont principalement utilis\u00e9es : Pour montrer au r\u00e9pondant un r\u00e9sultat calcul\u00e9 \u00e0 partir de ses r\u00e9ponses (score, note obtenue, conditions de pr\u00eat, etc.). Pour synth\u00e9tiser par une valeur simple 0 ou 1 une condition complexe [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[70],"doc_tag":[],"class_list":["post-12081","docs","type-docs","status-publish","hentry","doc_category-net-survey"],"acf":[],"year_month":"2026-08","word_count":1058,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Chloe","author_nicename":"chloe","author_url":"https:\/\/www.soft-concept.com\/en\/author\/chloe\/"},"doc_category_info":[{"term_name":"Net Survey","term_url":"https:\/\/www.soft-concept.com\/en\/documentation-categorie\/net-survey\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Questions calcul\u00e9es - Soft Concept<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.soft-concept.com\/en\/documentation\/questions_calculees\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Questions calcul\u00e9es - Soft Concept\" \/>\n<meta property=\"og:description\" content=\"La question calcul\u00e9e est le r\u00e9sultat d\u2019une formule de calcul qui renverra une valeur num\u00e9rique ou vide. Les variables calcul\u00e9es sont principalement utilis\u00e9es : Pour montrer au r\u00e9pondant un r\u00e9sultat calcul\u00e9 \u00e0 partir de ses r\u00e9ponses (score, note obtenue, conditions de pr\u00eat, etc.). Pour synth\u00e9tiser par une valeur simple 0 ou 1 une condition complexe [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.soft-concept.com\/en\/documentation\/questions_calculees\/\" \/>\n<meta property=\"og:site_name\" content=\"Soft Concept\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-01T16:11:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.soft-concept.com\/wp-content\/uploads\/2026\/05\/principe-de-fonctionnement.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/documentation\\\/questions_calculees\\\/\",\"url\":\"https:\\\/\\\/www.soft-concept.com\\\/documentation\\\/questions_calculees\\\/\",\"name\":\"Questions calcul\u00e9es - Soft Concept\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/documentation\\\/questions_calculees\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/documentation\\\/questions_calculees\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.soft-concept.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/principe-de-fonctionnement.png\",\"datePublished\":\"2026-05-28T15:20:14+00:00\",\"dateModified\":\"2026-06-01T16:11:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/documentation\\\/questions_calculees\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.soft-concept.com\\\/documentation\\\/questions_calculees\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/documentation\\\/questions_calculees\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.soft-concept.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/principe-de-fonctionnement.png\",\"contentUrl\":\"https:\\\/\\\/www.soft-concept.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/principe-de-fonctionnement.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/documentation\\\/questions_calculees\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.soft-concept.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Documentation\",\"item\":\"https:\\\/\\\/www.soft-concept.com\\\/documentation\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Questions calcul\u00e9es\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/#website\",\"url\":\"https:\\\/\\\/www.soft-concept.com\\\/\",\"name\":\"Soft Concept\",\"description\":\"Toute la chaine de vos datas au m\u00eame endroit\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.soft-concept.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/#organization\",\"name\":\"Soft Concept\",\"url\":\"https:\\\/\\\/www.soft-concept.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.soft-concept.com\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/cropped-soft-concept-scaled-1.png\",\"contentUrl\":\"https:\\\/\\\/www.soft-concept.com\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/cropped-soft-concept-scaled-1.png\",\"width\":2558,\"height\":668,\"caption\":\"Soft Concept\"},\"image\":{\"@id\":\"https:\\\/\\\/www.soft-concept.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/soft-concept\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculated Questions - Soft Concept","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.soft-concept.com\/en\/documentation\/questions_calculees\/","og_locale":"en_GB","og_type":"article","og_title":"Questions calcul\u00e9es - Soft Concept","og_description":"La question calcul\u00e9e est le r\u00e9sultat d\u2019une formule de calcul qui renverra une valeur num\u00e9rique ou vide. Les variables calcul\u00e9es sont principalement utilis\u00e9es : Pour montrer au r\u00e9pondant un r\u00e9sultat calcul\u00e9 \u00e0 partir de ses r\u00e9ponses (score, note obtenue, conditions de pr\u00eat, etc.). Pour synth\u00e9tiser par une valeur simple 0 ou 1 une condition complexe [&hellip;]","og_url":"https:\/\/www.soft-concept.com\/en\/documentation\/questions_calculees\/","og_site_name":"Soft Concept","article_modified_time":"2026-06-01T16:11:24+00:00","og_image":[{"url":"https:\/\/www.soft-concept.com\/wp-content\/uploads\/2026\/05\/principe-de-fonctionnement.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.soft-concept.com\/documentation\/questions_calculees\/","url":"https:\/\/www.soft-concept.com\/documentation\/questions_calculees\/","name":"Calculated Questions - Soft Concept","isPartOf":{"@id":"https:\/\/www.soft-concept.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.soft-concept.com\/documentation\/questions_calculees\/#primaryimage"},"image":{"@id":"https:\/\/www.soft-concept.com\/documentation\/questions_calculees\/#primaryimage"},"thumbnailUrl":"https:\/\/www.soft-concept.com\/wp-content\/uploads\/2026\/05\/principe-de-fonctionnement.png","datePublished":"2026-05-28T15:20:14+00:00","dateModified":"2026-06-01T16:11:24+00:00","breadcrumb":{"@id":"https:\/\/www.soft-concept.com\/documentation\/questions_calculees\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.soft-concept.com\/documentation\/questions_calculees\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.soft-concept.com\/documentation\/questions_calculees\/#primaryimage","url":"https:\/\/www.soft-concept.com\/wp-content\/uploads\/2026\/05\/principe-de-fonctionnement.png","contentUrl":"https:\/\/www.soft-concept.com\/wp-content\/uploads\/2026\/05\/principe-de-fonctionnement.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.soft-concept.com\/documentation\/questions_calculees\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.soft-concept.com\/"},{"@type":"ListItem","position":2,"name":"Documentation","item":"https:\/\/www.soft-concept.com\/documentation\/"},{"@type":"ListItem","position":3,"name":"Questions calcul\u00e9es"}]},{"@type":"WebSite","@id":"https:\/\/www.soft-concept.com\/#website","url":"https:\/\/www.soft-concept.com\/","name":"Soft Concept","description":"Your entire data chain in one place","publisher":{"@id":"https:\/\/www.soft-concept.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.soft-concept.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.soft-concept.com\/#organization","name":"Soft Concept","url":"https:\/\/www.soft-concept.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.soft-concept.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.soft-concept.com\/wp-content\/uploads\/2026\/01\/cropped-soft-concept-scaled-1.png","contentUrl":"https:\/\/www.soft-concept.com\/wp-content\/uploads\/2026\/01\/cropped-soft-concept-scaled-1.png","width":2558,"height":668,"caption":"Soft Concept"},"image":{"@id":"https:\/\/www.soft-concept.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/soft-concept"]}]}},"_links":{"self":[{"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/docs\/12081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/comments?post=12081"}],"version-history":[{"count":14,"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/docs\/12081\/revisions"}],"predecessor-version":[{"id":13237,"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/docs\/12081\/revisions\/13237"}],"wp:attachment":[{"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/media?parent=12081"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/doc_category?post=12081"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.soft-concept.com\/en\/wp-json\/wp\/v2\/doc_tag?post=12081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}