{"id":965,"date":"2022-12-05T06:37:52","date_gmt":"2022-12-05T06:37:52","guid":{"rendered":"https:\/\/www.softwaretestingstuff.com\/?p=965"},"modified":"2023-03-07T05:26:27","modified_gmt":"2023-03-07T05:26:27","slug":"how-to-use-formulas-in-checkpoints","status":"publish","type":"post","link":"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html","title":{"rendered":"How to use Formulas in Checkpoints"},"content":{"rendered":"\n<p>You can use a formula in a checkpoint to confirm that an object created on-the-fly or another variable object in your Web page or application contains the value it should for a given context. For example, suppose a shopping cart Web site displays a price total. You can create a text checkpoint on the displayed total value and use a Data Table formula to check whether the site properly computes the total, based on the individual prices of the products selected for purchase in each iteration.<\/p>\n\n\n\n<p>When you use the Data Table formula option with a checkpoint, QTP creates two columns in the Data Table. The first column contains a default checkpoint formula. The second column contains the value to be checked in the form of an output parameter. The result of the formula is Boolean\u2014TRUE or FALSE.<\/p>\n\n\n\n<p>A FALSE result in the checkpoint column during a test run causes the test to fail. After you finish adding the checkpoint, you can modify the default formula in the first column to perform the check you need.<\/p>\n\n\n\n<p>You may need to follow below steps to use a formula in a checkpoint in QTP:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the object or text for which you want to create a checkpoint and open the Insert Checkpoint dialog box.<\/li>\n\n\n\n<li>In the&nbsp;Configure value&nbsp;area, click&nbsp;Parameter.<\/li>\n\n\n\n<li>Click the&nbsp;Parameter Options&nbsp;button.<\/li>\n\n\n\n<li>Select&nbsp;Data Table&nbsp;as the parameter type and choose a parameter from the&nbsp;Parameter name&nbsp;box list or enter a new name.\n<ul class=\"wp-block-list\">\n<li>To use an existing parameter, select it from the list<\/li>\n\n\n\n<li>To create a new parameter, either use the default parameter name or enter a descriptive name for the parameter<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Select the&nbsp;Use Data Table formula&nbsp;check box and click&nbsp;<strong>OK<\/strong>&nbsp;to close the Parameter Options dialog box.<\/li>\n\n\n\n<li>Specify your other checkpoint setting preferences. Click&nbsp;<strong>OK.&nbsp;<\/strong>The two columns are added to the table, and the checkpoint step is inserted into your test.<\/li>\n\n\n\n<li>Highlight the value in the first (formula) column to view the formula and modify the formula to fit your needs.<\/li>\n\n\n\n<li>If you want to run several iterations, add the appropriate formula in subsequent rows of the formula column for each iteration in the test or action.<\/li>\n<\/ul>\n\n\n\n<p>In QTP, please note that that you cannot select&nbsp;<strong>Use Data Table formula<\/strong>&nbsp;if&nbsp;<strong><strong>Regular expression<\/strong><\/strong>&nbsp;is selected.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can use a formula in a checkpoint to confirm that an object created on-the-fly or another variable object in your Web page or application contains the value it should for a given context. For example, suppose a shopping cart Web site displays a price total. You can create a text checkpoint on the displayed [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[14],"tags":[],"table_tags":[],"class_list":["post-965","post","type-post","status-publish","format-standard","hentry","category-software-testing-certification"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to use Formulas in Checkpoints - Software Testing Stuff<\/title>\n<meta name=\"description\" content=\"Master the art of using formulas in checkpoints with these easy-to-follow tips and tricks. Boost your productivity and streamline your Excel game today!\" \/>\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.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use Formulas in Checkpoints - Software Testing Stuff\" \/>\n<meta property=\"og:description\" content=\"Master the art of using formulas in checkpoints with these easy-to-follow tips and tricks. Boost your productivity and streamline your Excel game today!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html\" \/>\n<meta property=\"og:site_name\" content=\"Software Testing Stuff\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/tdipto\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-05T06:37:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-07T05:26:27+00:00\" \/>\n<meta name=\"author\" content=\"Rahnuma Tasnim\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@tanvir@softwaretestingstuff.com\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rahnuma Tasnim\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html\"},\"author\":{\"name\":\"Rahnuma Tasnim\",\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#\/schema\/person\/388084d27e3299c8bdcdc784ba5600bc\"},\"headline\":\"How to use Formulas in Checkpoints\",\"datePublished\":\"2022-12-05T06:37:52+00:00\",\"dateModified\":\"2023-03-07T05:26:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html\"},\"wordCount\":408,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#organization\"},\"articleSection\":[\"Software Testing Certification\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html\",\"url\":\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html\",\"name\":\"How to use Formulas in Checkpoints - Software Testing Stuff\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#website\"},\"datePublished\":\"2022-12-05T06:37:52+00:00\",\"dateModified\":\"2023-03-07T05:26:27+00:00\",\"description\":\"Master the art of using formulas in checkpoints with these easy-to-follow tips and tricks. Boost your productivity and streamline your Excel game today!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwaretestingstuff.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use Formulas in Checkpoints\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#website\",\"url\":\"https:\/\/www.softwaretestingstuff.com\/\",\"name\":\"Software Testing Stuff\",\"description\":\"Unlock the power of efficient testing and elevate your testing game\",\"publisher\":{\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.softwaretestingstuff.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#organization\",\"name\":\"Software Testing Stuff\",\"url\":\"https:\/\/www.softwaretestingstuff.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.softwaretestingstuff.com\/wp-content\/uploads\/2022\/12\/logo-sts.png\",\"contentUrl\":\"https:\/\/www.softwaretestingstuff.com\/wp-content\/uploads\/2022\/12\/logo-sts.png\",\"width\":3268,\"height\":455,\"caption\":\"Software Testing Stuff\"},\"image\":{\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#\/schema\/person\/388084d27e3299c8bdcdc784ba5600bc\",\"name\":\"Rahnuma Tasnim\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwaretestingstuff.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/41c8421a46bfdc7a8c3777359a8ce20e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/41c8421a46bfdc7a8c3777359a8ce20e?s=96&d=mm&r=g\",\"caption\":\"Rahnuma Tasnim\"},\"description\":\"Rahnuma is a technical content writer at software testing stuff. A software engineer by degree and a dynamic content creator by passion, she brings to table over 3 years of writing experience in tech niche. Combining her enthusiasm for writing and technology, she loves to share her thoughts on the latest tech trends.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/rahnuma-tasnim-770402216\/\",\"https:\/\/www.facebook.com\/tdipto\",\"https:\/\/x.com\/tanvir@softwaretestingstuff.com\"],\"url\":\"https:\/\/www.softwaretestingstuff.com\/author\/tanvirsoftwaretestingstuff-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to use Formulas in Checkpoints - Software Testing Stuff","description":"Master the art of using formulas in checkpoints with these easy-to-follow tips and tricks. Boost your productivity and streamline your Excel game today!","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.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html","og_locale":"en_US","og_type":"article","og_title":"How to use Formulas in Checkpoints - Software Testing Stuff","og_description":"Master the art of using formulas in checkpoints with these easy-to-follow tips and tricks. Boost your productivity and streamline your Excel game today!","og_url":"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html","og_site_name":"Software Testing Stuff","article_author":"https:\/\/www.facebook.com\/tdipto","article_published_time":"2022-12-05T06:37:52+00:00","article_modified_time":"2023-03-07T05:26:27+00:00","author":"Rahnuma Tasnim","twitter_card":"summary_large_image","twitter_creator":"@tanvir@softwaretestingstuff.com","twitter_misc":{"Written by":"Rahnuma Tasnim","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html#article","isPartOf":{"@id":"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html"},"author":{"name":"Rahnuma Tasnim","@id":"https:\/\/www.softwaretestingstuff.com\/#\/schema\/person\/388084d27e3299c8bdcdc784ba5600bc"},"headline":"How to use Formulas in Checkpoints","datePublished":"2022-12-05T06:37:52+00:00","dateModified":"2023-03-07T05:26:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html"},"wordCount":408,"commentCount":0,"publisher":{"@id":"https:\/\/www.softwaretestingstuff.com\/#organization"},"articleSection":["Software Testing Certification"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html","url":"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html","name":"How to use Formulas in Checkpoints - Software Testing Stuff","isPartOf":{"@id":"https:\/\/www.softwaretestingstuff.com\/#website"},"datePublished":"2022-12-05T06:37:52+00:00","dateModified":"2023-03-07T05:26:27+00:00","description":"Master the art of using formulas in checkpoints with these easy-to-follow tips and tricks. Boost your productivity and streamline your Excel game today!","breadcrumb":{"@id":"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwaretestingstuff.com\/2013\/08\/how-to-use-formulas-in-checkpoints.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwaretestingstuff.com\/"},{"@type":"ListItem","position":2,"name":"How to use Formulas in Checkpoints"}]},{"@type":"WebSite","@id":"https:\/\/www.softwaretestingstuff.com\/#website","url":"https:\/\/www.softwaretestingstuff.com\/","name":"Software Testing Stuff","description":"Unlock the power of efficient testing and elevate your testing game","publisher":{"@id":"https:\/\/www.softwaretestingstuff.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.softwaretestingstuff.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.softwaretestingstuff.com\/#organization","name":"Software Testing Stuff","url":"https:\/\/www.softwaretestingstuff.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwaretestingstuff.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.softwaretestingstuff.com\/wp-content\/uploads\/2022\/12\/logo-sts.png","contentUrl":"https:\/\/www.softwaretestingstuff.com\/wp-content\/uploads\/2022\/12\/logo-sts.png","width":3268,"height":455,"caption":"Software Testing Stuff"},"image":{"@id":"https:\/\/www.softwaretestingstuff.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.softwaretestingstuff.com\/#\/schema\/person\/388084d27e3299c8bdcdc784ba5600bc","name":"Rahnuma Tasnim","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwaretestingstuff.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/41c8421a46bfdc7a8c3777359a8ce20e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41c8421a46bfdc7a8c3777359a8ce20e?s=96&d=mm&r=g","caption":"Rahnuma Tasnim"},"description":"Rahnuma is a technical content writer at software testing stuff. A software engineer by degree and a dynamic content creator by passion, she brings to table over 3 years of writing experience in tech niche. Combining her enthusiasm for writing and technology, she loves to share her thoughts on the latest tech trends.","sameAs":["https:\/\/www.linkedin.com\/in\/rahnuma-tasnim-770402216\/","https:\/\/www.facebook.com\/tdipto","https:\/\/x.com\/tanvir@softwaretestingstuff.com"],"url":"https:\/\/www.softwaretestingstuff.com\/author\/tanvirsoftwaretestingstuff-com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/posts\/965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/comments?post=965"}],"version-history":[{"count":0,"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/posts\/965\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/media?parent=965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/categories?post=965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/tags?post=965"},{"taxonomy":"table_tags","embeddable":true,"href":"https:\/\/www.softwaretestingstuff.com\/wp-json\/wp\/v2\/table_tags?post=965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}