{"id":36756,"date":"2018-02-12T20:01:44","date_gmt":"2018-02-12T12:01:44","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=36756"},"modified":"2018-10-12T16:18:22","modified_gmt":"2018-10-12T08:18:22","slug":"using-the-calculation-tester-4-4-5","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/configuring-your-system\/creating-a-calculation\/using-the-calculation-tester\/using-the-calculation-tester-4-4-5\/","title":{"rendered":"Using the Calculation Tester (4.4.5)"},"content":{"rendered":"\n<p class=\"left-bar\">This article applies to P2 Server versions 4.4.5-4.5.4. For the latest, see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/configuring-your-system\/creating-a-calculation\/using-the-calculation-tester\/\">Using the Calculation Tester<\/a>.<\/p>\n<p class=\"overview\">The Calculation Tester is a fully-featured tool that allows you to test the results of your calculation.<\/p>\n<p class=\"intro-text\">This allows you to have even greater confidence in the calculation, beyond simply knowing that the syntax is correct, and enables you to determine whether or not you are getting the data you need from the calculation.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-tester-callouts.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-24387 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-tester-callouts.png\" width=\"1603\" height=\"485\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-tester-callouts.png 1603w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-tester-callouts-768x232.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-tester-callouts-150x45.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-tester-callouts-1280x387.png 1280w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-tester-callouts-24x7.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-tester-callouts-36x11.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-tester-callouts-48x15.png 48w\" sizes=\"auto, (max-width: 1603px) 100vw, 1603px\" \/><\/a><\/p>\n<p class=\"intro-text\">With the calculation tester, you can compare test results of the calculation run against different inputs, including:<\/p>\n<ul class=\"intro-text\">\n<li>Entity (if required)<\/li>\n<li>Time Range (calculated from <em>'now')<\/em><\/li>\n<li>Sample Method<\/li>\n<li>Sample Interval<\/li>\n<\/ul>\n<p class=\"intro-text\">You can also:<\/p>\n<ul class=\"intro-text\">\n<li>Export test results<\/li>\n<li>Open test results in separate windows, and keep them open so you can compare the results of different inputs<\/li>\n<li>See the time taken to run the calculation<\/li>\n<\/ul>\n<p class=\"intro-text\">The \u2018Test\u2019 button will become available only when the calculation is recognised as being syntactically correct.\u00a0\u00a0<\/p>\n<p class=\"intro-text\">The Test Results are displayed below the parameters, after the \u2018Test\u2019 button is clicked. The results show not only the returned data, but also a summary of the parameters used, as well as the time taken for the calculation and options to export to .csv or to open the results in a new window.<\/p>\n<p class=\"left-bar\">Related: <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/configuring-your-system\/creating-a-calculation\/\">Creating a Calculation<\/a>, <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/configuring-your-system\/creating-a-calculation\/using-the-calculation-editor\/\">Using the Calculation Editor<\/a><\/p>\n<p class=\"intro-text\">\u00a0<\/p>\n<h2 class=\"page-subheading\">How to Use the Calculation Tester<\/h2>\n<p class=\"intro-text\">The tester will only become available when the error tab displays no errors, and when all of the required input parameters have been entered.<\/p>\n<p class=\"intro-text\"><strong>Step 1. Ensure no errors<\/strong><\/p>\n<p class=\"intro-text\">First, ensure that the Error tab displays no errors. The Test button will not be available if the calculation expression contains any syntax errors. These can include:<\/p>\n<ul>\n<li class=\"intro-text\">Mismatched brackets<\/li>\n<li class=\"intro-text\">Use of square brackets [] - these are used as placeholders for optional parameters in functions, and are intended to be replaced<\/li>\n<li class=\"intro-text\">Unrecognised keywords, e.g. Time being used instead of Time()<\/li>\n<\/ul>\n<div id=\"attachment_24389\" style=\"width: 1218px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-syntax.png\" rel=\"lightbox-1\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24389\" class=\"wp-image-24389 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-syntax.png\" width=\"1208\" height=\"95\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-syntax.png 1208w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-syntax-768x60.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-syntax-150x12.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-syntax-24x2.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-syntax-36x3.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-syntax-48x4.png 48w\" sizes=\"auto, (max-width: 1208px) 100vw, 1208px\" \/><\/a><p id=\"caption-attachment-24389\" class=\"wp-caption-text\">Syntax error in calculation expression<\/p><\/div>\n<p class=\"intro-text\"><strong>Step 2. Complete all required test inputs<\/strong><\/p>\n<p class=\"intro-text\">By default, the Time Range, Sample Method, and Sample Interval are completed by default, but can be changed by selecting values from the drop down list (for Time Range and Sample Method), or by entering an number for the Sample Interval (the default of 300 seconds represents 5 minutes). \u00a0<\/p>\n<div id=\"attachment_24392\" style=\"width: 1217px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active2.png\" rel=\"lightbox-2\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24392\" class=\"wp-image-24392 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active2.png\" width=\"1207\" height=\"71\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active2.png 1207w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active2-768x45.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active2-150x9.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active2-24x1.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active2-36x2.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active2-48x3.png 48w\" sizes=\"auto, (max-width: 1207px) 100vw, 1207px\" \/><\/a><p id=\"caption-attachment-24392\" class=\"wp-caption-text\">All required inputs are completed, inputs not required are greyed out, and test button becomes available<\/p><\/div>\n<p class=\"intro-text\">However, if\u00a0your expression requires an entity name, you will need to enter the name in the Selected Entity field before the Test button becomes available.<\/p>\n<div id=\"attachment_24390\" style=\"width: 1219px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-entity.png\" rel=\"lightbox-3\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24390\" class=\"wp-image-24390 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-entity.png\" width=\"1209\" height=\"95\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-entity.png 1209w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-entity-768x60.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-entity-150x12.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-entity-24x2.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-entity-36x3.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-entity-48x4.png 48w\" sizes=\"auto, (max-width: 1209px) 100vw, 1209px\" \/><\/a><p id=\"caption-attachment-24390\" class=\"wp-caption-text\">Required input not entered<\/p><\/div>\n<p class=\"intro-text\">Click in the field and start typing, and a drop-down list will appear and be filtered as you type.\u00a0<\/p>\n<div id=\"attachment_24449\" style=\"width: 290px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-entity-field.png\" rel=\"lightbox-4\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24449\" class=\"wp-image-24449 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-entity-field.png\" width=\"280\" height=\"268\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-entity-field.png 280w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-entity-field-150x144.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-entity-field-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-entity-field-36x34.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-entity-field-48x46.png 48w\" sizes=\"auto, (max-width: 280px) 100vw, 280px\" \/><\/a><p id=\"caption-attachment-24449\" class=\"wp-caption-text\">Selected Entity drop-down list, being filtered as you type<\/p><\/div>\n<p class=\"intro-text\">Select your entity from the list by using the arrow keys, and clicking Enter when your entity is highlighted.<\/p>\n<div id=\"attachment_24391\" style=\"width: 1218px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active.png\" rel=\"lightbox-5\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24391\" class=\"wp-image-24391 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active.png\" width=\"1208\" height=\"71\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active.png 1208w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active-768x45.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active-150x9.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active-24x1.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active-36x2.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-active-48x3.png 48w\" sizes=\"auto, (max-width: 1208px) 100vw, 1208px\" \/><\/a><p id=\"caption-attachment-24391\" class=\"wp-caption-text\">All inputs completed, and test button becomes available<\/p><\/div>\n<p>&nbsp;<\/p>\n<p class=\"intro-text\"><strong>Step 3. Click Test\u00a0<\/strong><\/p>\n<p class=\"intro-text\">When you have no errors and all your inputs have been completed, click the <strong>Test<\/strong> button. The test will run and your results are displayed in the panel below.<\/p>\n<p>&nbsp;<\/p>\n<h2 class=\"page-subheading\">What to Do With Your Results<\/h2>\n<p class=\"intro-text\">Your results appear in the Test panel after you have clicked the <strong>Test<\/strong> button.<\/p>\n<p class=\"intro-text\">Here you can check your fetch results, the parameters you used, the expression being tested, and the performance of the calculation.<\/p>\n<h3>Save Your Results<\/h3>\n<p class=\"intro-text\">If you want to save your test results for future reference, click the <strong>Export CSV<\/strong> button. This will enable you to download the test results in .csv format.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-export.png\" rel=\"lightbox-6\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24466\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-export.png\" alt=\"\" width=\"955\" height=\"356\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-export.png 955w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-export-768x286.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-export-150x56.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-export-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-export-36x13.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-export-48x18.png 48w\" sizes=\"auto, (max-width: 955px) 100vw, 955px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>Retest Using Different Parameters<\/h3>\n<p class=\"intro-text\">If you want to test your expression using different parameters, you can also display your current test results in a new window, by clicking the <strong>Open in New Window<\/strong> button.\u00a0<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-window.png\" rel=\"lightbox-7\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24467\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-window.png\" alt=\"\" width=\"955\" height=\"356\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-window.png 955w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-window-768x286.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-window-150x56.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-window-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-window-36x13.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-window-48x18.png 48w\" sizes=\"auto, (max-width: 955px) 100vw, 955px\" \/><\/a><\/p>\n<p class=\"intro-text\">You can then retest the calculation, and display the two sets of results side by side for comparison. You can have several result windows open at the same time, closing them individually as needed.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-result-window.png\" rel=\"lightbox-8\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24468\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-result-window.png\" alt=\"\" width=\"1681\" height=\"948\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-result-window.png 1681w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-result-window-768x433.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-result-window-150x85.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-result-window-1280x722.png 1280w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-result-window-24x14.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-result-window-36x20.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/02\/calc-test-result-window-48x27.png 48w\" sizes=\"auto, (max-width: 1681px) 100vw, 1681px\" \/><\/a><\/p>\n<p class=\"intro-text\">All the information from the test panel, including fetch results, parameters used, expression tested, and performance results, are displayed in the floating windows.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Calculation Tester is a fully-featured tool that allows you to test the results of your calculation. This article describes how to use it.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/configuring-your-system\/creating-a-calculation\/using-the-calculation-tester\/using-the-calculation-tester-4-4-5\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":36105,"parent":24380,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[4],"tags":[100],"class_list":["post-36756","page","type-page","status-publish","has-post-thumbnail","hentry","category-explainer","tag-calculations","Version-4-5-0","Version-4-5-1","Version-4-5-2","Version-4-5-3","Version-4-5-4","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/36756","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=36756"}],"version-history":[{"count":0,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/36756\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/24380"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/36105"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=36756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=36756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=36756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}