{"id":82259,"date":"2021-10-07T16:40:31","date_gmt":"2021-10-07T07:40:31","guid":{"rendered":"https:\/\/support.questetra.com\/developer-blog\/service-task-calculation-decimal\/"},"modified":"2026-04-14T15:19:28","modified_gmt":"2026-04-14T06:19:28","slug":"service-task-calculation-decimal","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/","title":{"rendered":"Let&#8217;s Calculate the Total Amount Automatically"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"58\" data-attachment-id=\"113114\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/first-questetra-bpm-suite-step1\/attachment\/basic-banner-new-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"basic-banner-new-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en-1024x58.png?resize=1024%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-113114\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=768%2C44&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">I\u2019m wondering whether you would like to add an automatic money calculation function to the workflow App for goods purchasing requests. The App will allow you to calculate not only the total and subtotal, but also to change the formula depending on the conditions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this post, I would like to illustrate how to implement a system that not only calculates the total amount based on the purchase list but also does a discount calculation which deducts 50% from payments exceeding $1000 of the total amount using a split in the workflow diagram. A <strong>Table-type<\/strong> Data Item and a <strong>Update Data<\/strong> are vital elements for the design of this App.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Calculation of the Total Amount with a Table-type Data Item<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">First of all, we\u2019d like you to create an App, setting a Table-type Data Item for listing the purchased items and make it calculate the total automatically.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Workflow Diagram<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Please create a new App and set up the workflow diagram as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"870\" height=\"137\" data-attachment-id=\"126893\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-workflow-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-workflow-en.png?fit=870%2C137&amp;ssl=1\" data-orig-size=\"870,137\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-workflow-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-workflow-en.png?fit=870%2C137&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-workflow-en.png?resize=870%2C137&#038;ssl=1\" alt=\"\" class=\"wp-image-126893\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-workflow-en.png?w=870&amp;ssl=1 870w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-workflow-en.png?resize=600%2C94&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-workflow-en.png?resize=768%2C121&amp;ssl=1 768w\" sizes=\"auto, (max-width: 870px) 100vw, 870px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Data Items<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s prepare the following data items.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Data Item Name<\/strong><\/td><td><strong>Data-type<\/strong><\/td><td><strong>Field Name<\/strong><\/td><td><strong>Remarks<\/strong><\/td><\/tr><tr><td>Title<\/td><td>&#8211;<\/td><td><\/td><td><\/td><\/tr><tr><td>Purchase list<\/td><td>Table<\/td><td>q_purchase_list<\/td><td>Set the 4 sections, <strong>Description<\/strong> (String)\/<strong> Unit Price<\/strong> (Numeric)\/<strong> Quantity<\/strong> (Numeric)\/<strong> Subtotal<\/strong> (Numeric)<\/td><\/tr><tr><td>Total<\/td><td>Numeric-type<\/td><td>q_total<\/td><td>Automatically input the total value of:<strong> Purchase list\u2013Subtotal<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Purchase List Settings<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">In Purchase List (Table-type Data Item) <strong>set up 4 table columns,<\/strong> which are labelled Description, Unit Price, Quantity, and Subtotal respectively.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"431\" data-attachment-id=\"114992\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-table_add-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-table_add-en.png?fit=900%2C431&amp;ssl=1\" data-orig-size=\"900,431\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-table_add-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-table_add-en.png?fit=900%2C431&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-table_add-en.png?resize=900%2C431&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-114992\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-table_add-en.png?w=900&amp;ssl=1 900w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-table_add-en.png?resize=600%2C287&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-table_add-en.png?resize=768%2C368&amp;ssl=1 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">In the Subtotal column the subtotal of each row in the table is calculated and saved. Check the \u201cShow total value at the bottom of list&#8221; box as well. In addition, it is mandatory to set the Field Name for a column that is set to display the sum. Please be sure to set it. (This Field Name does not have to start with \u201cq_\u201d.)<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"114994\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-table-setting-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-table-setting-en.png?fit=1053%2C1025&amp;ssl=1\" data-orig-size=\"1053,1025\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-table-setting-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-table-setting-en.png?fit=647%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/update_data-calculation-table-setting-en1.png?ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-114994\"><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Then you should set up a Numeric-type Data Item that saves the total value of the Table-type Data Item using the arithmetic expression settings window. The expression is automatically inserted into the text box.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"614\" data-attachment-id=\"167107\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-item-setting-en-1\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/update_data-calculation-item-setting-en-1.png?fit=640%2C614&amp;ssl=1\" data-orig-size=\"640,614\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-item-setting-en-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/update_data-calculation-item-setting-en-1.png?fit=640%2C614&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/update_data-calculation-item-setting-en-1.png?resize=640%2C614&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-167107\" style=\"border-color:#aaaaaa;border-width:10px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/update_data-calculation-item-setting-en-1.png?w=640&amp;ssl=1 640w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/update_data-calculation-item-setting-en-1.png?resize=328%2C315&amp;ssl=1 328w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Data editing permission Settings<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Please set up as in the following figure.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><\/td><td><strong>Enter<\/strong><\/td><td><strong>Confirmation<\/strong><\/td><\/tr><tr><td>Title<\/td><td>Editable <span style=\"color: royalblue;\"><i class=\"fas fa-pen fa-lg\" data-fa-transform=\"shrink-8\" data-fa-mask=\"fas fa-circle\"><\/i><\/span><\/td><td>Only display <span style=\"color: Orange;\"><i class=\"fas fa-eye fa-lg fa-flip-horizontal\" data-fa-transform=\"shrink-7\" data-fa-mask=\"fas fa-circle\"><\/i><\/span><\/td><\/tr><tr><td>Purchase list<\/td><td>Editable <span style=\"color: royalblue;\"><i class=\"fas fa-pen fa-lg\" data-fa-transform=\"shrink-8\" data-fa-mask=\"fas fa-circle\"><\/i><\/span><\/td><td>Only display <span style=\"color: Orange;\"><i class=\"fas fa-eye fa-lg fa-flip-horizontal\" data-fa-transform=\"shrink-7\" data-fa-mask=\"fas fa-circle\"><\/i><\/span><\/td><\/tr><tr><td>Total<\/td><td>No display <span style=\"color: Red;\"><i class=\"fas fa-eye-slash fa-lg fa-flip-horizontal\" data-fa-transform=\"shrink-7\" data-fa-mask=\"fas fa-circle\"><\/i><\/span><\/td><td>Only display <span style=\"color: Orange;\"><i class=\"fas fa-eye fa-lg fa-flip-horizontal\" data-fa-transform=\"shrink-7\" data-fa-mask=\"fas fa-circle\"><\/i><\/span><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You\u2019ve created an app that calculates the total amount from the Purchase list using a Table-type Data Item. Please exit editing and release it now to see how it works.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"630\" data-attachment-id=\"126896\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-testrun-form-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-form-en.png?fit=1300%2C982&amp;ssl=1\" data-orig-size=\"1300,982\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-testrun-form-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-form-en.png?fit=834%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-form-en-834x630.png?resize=834%2C630&#038;ssl=1\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" alt=\"\" class=\"wp-image-126896\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-form-en.png?resize=834%2C630&amp;ssl=1 834w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-form-en.png?resize=417%2C315&amp;ssl=1 417w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-form-en.png?resize=768%2C580&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-form-en.png?w=1300&amp;ssl=1 1300w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When you finish the Task after entering the unit price and quantity of an item in the Purchase list, the total amount will be saved in the Total section.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Discount Calculations Using Update Data<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Now let\u2019s implement a workflow that performs automatic calculations under the condition of a 50% discount for payments where the total is over $1000.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Workflow Diagram<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s add some changes to the initial workflow diagram that you made as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/06\/update_data-calculation-split-workflow-en-merge.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"889\" height=\"192\" data-attachment-id=\"147152\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-split-workflow-en-merge\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/06\/update_data-calculation-split-workflow-en-merge.png?fit=889%2C192&amp;ssl=1\" data-orig-size=\"889,192\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-split-workflow-en-merge\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/06\/update_data-calculation-split-workflow-en-merge.png?fit=889%2C192&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/06\/update_data-calculation-split-workflow-en-merge.png?resize=889%2C192&#038;ssl=1\" alt=\"\" class=\"wp-image-147152\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/06\/update_data-calculation-split-workflow-en-merge.png?w=889&amp;ssl=1 889w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/06\/update_data-calculation-split-workflow-en-merge.png?resize=600%2C130&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/06\/update_data-calculation-split-workflow-en-merge.png?resize=768%2C166&amp;ssl=1 768w\" sizes=\"auto, (max-width: 889px) 100vw, 889px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Set an Update Data icon in each split flow where the condition of the Task is set to more than $1000 and less than $1000 in the total amount. That enables the token to advance to the Task and set the condition of a 50% discount for payments exceeding $1000 in the total amount.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Settings in Exclusive Gateway (XOR)<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">You use an <strong>Exclusive Gateway (XOR)<\/strong> to control the flow based on whether the total amount is over $1000.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"420\" data-attachment-id=\"126900\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-split-setting-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-setting-en.png?fit=830%2C420&amp;ssl=1\" data-orig-size=\"830,420\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-split-setting-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-setting-en.png?fit=830%2C420&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-setting-en.png?resize=830%2C420&#038;ssl=1\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" alt=\"\" class=\"wp-image-126900\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-setting-en.png?w=830&amp;ssl=1 830w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-setting-en.png?resize=600%2C304&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-setting-en.png?resize=768%2C389&amp;ssl=1 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You have to add a flow for cases of over $1000 and set its destination to \u201cDiscount\u201d, whereas you set the destination of the Default Flow to \u201cNo Discount\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For the condition of the Total which is set over $1000, the Conditional Expression Setting is set as follows.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"955\" height=\"513\" data-attachment-id=\"126902\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-split-condition-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-condition-en.png?fit=955%2C513&amp;ssl=1\" data-orig-size=\"955,513\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-split-condition-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-condition-en.png?fit=955%2C513&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-condition-en.png?resize=955%2C513&#038;ssl=1\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" alt=\"\" class=\"wp-image-126902\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-condition-en.png?w=955&amp;ssl=1 955w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-condition-en.png?resize=586%2C315&amp;ssl=1 586w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-split-condition-en.png?resize=768%2C413&amp;ssl=1 768w\" sizes=\"auto, (max-width: 955px) 100vw, 955px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This setting enables the token to advance to the Discount Processing Task if the Total is $1000 or more, whereas the token advances to the No Discount Task if the total is less than $1000.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Data Item Settings<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Please add a Numeric-type Data Item called \u201cTotal Discounted Amount\u201d to save the discounted total.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Data Item Name<\/strong><\/td><td><strong>Data-type<\/strong><\/td><td><strong>Field Name<\/strong><\/td><td><strong>Remarks<\/strong><\/td><\/tr><tr><td>Total Discounted Amount<\/td><td>Numeric-type<\/td><td>q_discounted_total<\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><\/td><td><strong>Enter<\/strong><\/td><td><strong>Confirmation<\/strong><\/td><\/tr><tr><td>Total Discounted Amount<\/td><td>No display <span style=\"color: Red;\"><i class=\"fas fa-eye-slash fa-lg fa-flip-horizontal\" data-fa-transform=\"shrink-7\" data-fa-mask=\"fas fa-circle\"><\/i><\/span><\/td><td>Only display <span style=\"color: Orange;\"><i class=\"fas fa-eye fa-lg fa-flip-horizontal\" data-fa-transform=\"shrink-7\" data-fa-mask=\"fas fa-circle\"><\/i><\/span><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Settings in Update Data<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s set up two <strong>Update Data<\/strong> Steps respectively for the No Discount and Discount branches.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">No Discount<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Set up an expression for the Total which is less than $1000. Since it will not apply any discount, the value of Total should be saved in the Total Discounted Amount data item.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"508\" data-attachment-id=\"114999\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-update_data-not-setting-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-not-setting-en.png?fit=1052%2C522&amp;ssl=1\" data-orig-size=\"1052,522\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-update_data-not-setting-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-not-setting-en.png?fit=1024%2C508&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-not-setting-en-1024x508.png?resize=1024%2C508&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-114999\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-not-setting-en.png?resize=1024%2C508&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-not-setting-en.png?resize=600%2C298&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-not-setting-en.png?resize=768%2C381&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-not-setting-en.png?w=1052&amp;ssl=1 1052w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Discount<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Set up an expression for the Total which is over $1000. A 50% discount is given to the amount over $1000 so the expression is set as follows:<\/p>\n\n\n<div class=\"wp-block-code\">\n\t<div class=\"cm-editor\">\n\t\t<div class=\"cm-scroller\">\n\t\t\t\n<pre>\n<code><div class=\"cm-line\">100000 + (#q_total - 100000) * 0.5<\/div><\/code><\/pre>\n\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"513\" data-attachment-id=\"115001\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-update_data-setting-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-setting-en.png?fit=1052%2C527&amp;ssl=1\" data-orig-size=\"1052,527\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-update_data-setting-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-setting-en.png?fit=1024%2C513&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-setting-en-1024x513.png?resize=1024%2C513&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115001\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-setting-en.png?resize=1024%2C513&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-setting-en.png?resize=600%2C301&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-setting-en.png?resize=768%2C385&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-update_data-setting-en.png?w=1052&amp;ssl=1 1052w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure><\/div>\n\n\n\n<p class=\"has-very-light-gray-background-color has-background wp-block-paragraph\">* For the Numeric-type, numbers below the range of decimal digits specified in the settings of the Data item are truncated (e.g. if the range of decimal digits is 0, then the result of 1.5 (3 * 0.5) becomes 1 due to rounding down the first decimal place). The same thing will perform in the Numeric-type item in the table columns.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The settings of the App are now complete. You have to exit editing and release it to see how it works. In particular, I would like you to check that splitting by the Total is working and check for any mistakes in discount calculations.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"764\" height=\"630\" data-attachment-id=\"126906\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-testrun-nodiscount-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-nodiscount-en.png?fit=1300%2C1072&amp;ssl=1\" data-orig-size=\"1300,1072\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-testrun-nodiscount-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-nodiscount-en.png?fit=764%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-nodiscount-en-764x630.png?resize=764%2C630&#038;ssl=1\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" alt=\"\" class=\"wp-image-126906\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-nodiscount-en.png?resize=764%2C630&amp;ssl=1 764w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-nodiscount-en.png?resize=382%2C315&amp;ssl=1 382w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-nodiscount-en.png?resize=768%2C633&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-nodiscount-en.png?w=1300&amp;ssl=1 1300w\" sizes=\"auto, (max-width: 764px) 100vw, 764px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"630\" data-attachment-id=\"126908\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-testrun-discount-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-discount-en.png?fit=1297%2C1064&amp;ssl=1\" data-orig-size=\"1297,1064\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-testrun-discount-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-discount-en.png?fit=768%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-discount-en-768x630.png?resize=768%2C630&#038;ssl=1\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" alt=\"\" class=\"wp-image-126908\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-discount-en.png?resize=768%2C630&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-discount-en.png?resize=384%2C315&amp;ssl=1 384w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/update_data-calculation-testrun-discount-en.png?w=1297&amp;ssl=1 1297w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Use of an Arithmetic expression in the Settings window (Numeric-type Data Item)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This time I used Update Data for the discount calculations to cope with the splitting process. However, the Expression field in the settings window of a Numeric-type Data Item can be used for arithmetic operations as well. For example, you can achieve a 50% discount by setting the same expression as with the Discount Task like in the figure below. However, you should remember that the Expression field in the settings window can\u2019t set a split condition for a 50% discount for payments over $1000.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"624\" data-attachment-id=\"115003\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/attachment\/update_data-calculation-item-setting-expression-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-item-setting-expression-en.png?fit=1055%2C643&amp;ssl=1\" data-orig-size=\"1055,643\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"update_data-calculation-item-setting-expression-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-item-setting-expression-en.png?fit=1024%2C624&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-item-setting-expression-en-1024x624.png?resize=1024%2C624&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115003\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-item-setting-expression-en.png?resize=1024%2C624&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-item-setting-expression-en.png?resize=517%2C315&amp;ssl=1 517w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-item-setting-expression-en.png?resize=768%2C468&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/update_data-calculation-item-setting-expression-en.png?w=1055&amp;ssl=1 1055w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Although within the settings window of a Numeric-type Data Item it is not possible to change expressions according to any conditions, it may not be necessary if the App doesn\u2019t require a splitting process. Please use the property according to the implementation you want.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As explained above, the use of a Table-type Data Item and Update Data will make it possible to perform various calculations. Questetra BPM Suite will help with troublesome monetary calculations that can change the formula according to the conditions faster without bothering any staff members.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Let&#8217;s implement a total amount calculation and a variable discount setup with conditions. A Table-type Data Item and a Update Data are vital.<\/p>\n","protected":false},"author":3,"featured_media":115008,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[296],"tags":[],"class_list":["post-82259","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-blog"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":3,"uagb_excerpt":"Let's implement a total amount calculation and a variable discount setup with conditions. A Table-type Data Item and a Update Data are vital.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-loL","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":69786,"url":"https:\/\/support.questetra.com\/en\/pdf\/pdf-invoice\/","url_meta":{"origin":82259,"position":0},"title":"Base PDF: Invoice","author":"Hirotaka NISHI","date":"2022-07-14","format":false,"excerpt":"A base PDF file for automatically generating an invoice based on the entered business data. Values such as recipient and issuer information, amounts, and details entered in the workflow are inserted into each field.","rel":"","context":"In &quot;Base PDF&quot;","block_context":{"text":"Base PDF","link":"https:\/\/support.questetra.com\/en\/category\/pdf\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-invoice-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-invoice-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-invoice-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-invoice-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-invoice-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":67575,"url":"https:\/\/support.questetra.com\/en\/pdf\/pdf-quote\/","url_meta":{"origin":82259,"position":1},"title":"Base PDF: Quotation","author":"Hirotaka NISHI","date":"2022-07-13","format":false,"excerpt":"A base PDF file for automatically generating a quotation based on the entered business data. Values such as recipient and issuer information, amounts, and details entered in the workflow are inserted into each field.","rel":"","context":"In &quot;Base PDF&quot;","block_context":{"text":"Base PDF","link":"https:\/\/support.questetra.com\/en\/category\/pdf\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-quote-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-quote-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-quote-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-quote-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/11\/pdf-quote-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76695,"url":"https:\/\/support.questetra.com\/en\/templates\/order-report-flow-20170116\/","url_meta":{"origin":82259,"position":2},"title":"Order Reporting App, Email Notification","author":"Hirotaka NISHI","date":"2021-02-15","format":false,"excerpt":"To be approved by the Sales Manager. Sales team leader makes [2. Confirmation], and then Sales Manager makes [3. Approval]. If the order value is over 1 million JPY, it will be also reported to the directors.","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/eye-catch-order-report-flow-20170116-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/eye-catch-order-report-flow-20170116-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/eye-catch-order-report-flow-20170116-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/eye-catch-order-report-flow-20170116-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/eye-catch-order-report-flow-20170116-220-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":75274,"url":"https:\/\/support.questetra.com\/en\/templates\/order-report-process-20170206\/","url_meta":{"origin":82259,"position":3},"title":"Order Report Process","author":"Hirotaka NISHI","date":"2021-01-21","format":false,"excerpt":"To be approved by the Sales Manager. Sales team leader makes [2. Confirmation], and then Sales Manager makes [3. Approval]. If the order value is over 1 million JPY, it will be also reported to the directors. Assumed to be invoked from Quotation Approval Process, etc.","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/eye-catch-order-report-process-20170206-218-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/eye-catch-order-report-process-20170206-218-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/eye-catch-order-report-process-20170206-218-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/eye-catch-order-report-process-20170206-218-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/eye-catch-order-report-process-20170206-218-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":81226,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-title\/","url_meta":{"origin":82259,"position":4},"title":"Let&#8217;s Set the Title Automatically","author":"Hirotaka NISHI","date":"2021-10-07","format":false,"excerpt":"Let's design your App so that the correct subject is automatically set for the process, using \"Update Data\".","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-title-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-title-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-title-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-title-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-title-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96429,"url":"https:\/\/support.questetra.com\/en\/incident\/bug-20201014\/","url_meta":{"origin":82259,"position":5},"title":"Value of Numeric Row Sum of Table-type may not be Reflected in Numeric-type (Fixed)","author":"Hirotaka NISHI","date":"2020-10-14","format":false,"excerpt":"Fixed Version: Ver. 12.2.1","rel":"","context":"In &quot;Incident Info&quot;","block_context":{"text":"Incident Info","link":"https:\/\/support.questetra.com\/en\/category\/incident\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=82259"}],"version-history":[{"count":44,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82259\/revisions"}],"predecessor-version":[{"id":181863,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82259\/revisions\/181863"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/115008"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=82259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=82259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=82259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}