{"id":109998,"date":"2021-07-20T16:28:57","date_gmt":"2021-07-20T07:28:57","guid":{"rendered":"https:\/\/support.questetra.com\/?p=109998"},"modified":"2021-11-22T12:20:22","modified_gmt":"2021-11-22T03:20:22","slug":"tsv-string-sum-of-number-column-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sum-of-number-column-2021\/","title":{"rendered":"TSV String; Sum of Number Column"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5dab2;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFF4CC;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-create-summary-table-for-numeric-column-2021\/\">https:\/\/support.questetra.com\/addons\/tsv-string-create-summary-table-for-numeric-column-2021\/<\/a><\/div>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sum-numeric-column-2021\/\">https:\/\/support.questetra.com\/addons\/tsv-string-sum-numeric-column-2021\/<\/a><\/div>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">TSV String; Sum of Number Column<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Calculates the sum of the values in a numeric column. If non-numeric data is mixed in the specified column, the record is regarded as zero and will not be added.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li> A: Select STRING DATA for TSV Text<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B: Set ID of Numeric Column to be summed (e.g. &#8220;0&#8221;)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> C: Select NUMERIC DATA for Sum of Column (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\/\/ (c) 2021, Questetra, Inc. (the MIT License)\n\n\/*\n=input tsv=\nA1\t10000\tC1\nA2\t$9900\tC2\nA3\t10800\tC3\n=column id=\n1\n=output value=\n20800\n*\/\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA = configs.get( &quot;conf_DataIdA&quot; ) + &quot;&quot;; \/\/ config required\nconst columnB = configs.get( &quot;conf_ColumnB&quot; ) + &quot;&quot;; \/\/ config required\nconst dataIdC = configs.get( &quot;conf_DataIdC&quot; ) + &quot;&quot;; \/\/ config required\n\/\/ &#39;java.lang.String&#39; to javascript primitive &#39;string&#39; by &quot;&quot;\n\nengine.log( &quot; AutomatedTask Config: ID of Numeric Column: &quot; + columnB );\n\n\/\/ Design-time Config Format Check\nconst intColumnB  = parseInt( columnB );\nif ( isNaN( intColumnB )){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {ID of Numeric Column} is not an integer \\n&quot; );\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ Run-time Data Format Check\nif( engine.findDataByNumber( dataIdA ) === null ){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                   &quot; String {A} as TSV is null \\n&quot; );\n}\nconst inputText = (engine.findDataByNumber( dataIdA ) + &quot;&quot;).trim();\nif( inputText === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                   &quot; String {A} as TSV is empty \\n&quot; );\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet   outputNum = 0;\nconst arrInputText = inputText.split(&quot;\\n&quot;);\nengine.log( &quot; AutomatedTask MultilineString:&quot; + \n            &quot; String {A} as TSV, number of lines: &quot; + arrInputText.length );\n\nfor( let i = 0; i &lt; arrInputText.length; i++ ){\n  let arrCellValues = arrInputText[i].split(&quot;\\t&quot;);\n  let strValueB = arrCellValues[ intColumnB ];\n  let numValueB = parseFloat( strValueB );\n  \/\/ Run-time Data Format Check\n  if ( isNaN( numValueB )){\n    engine.log( &quot; AutomatedTask StringWarning:&quot; +\n                &quot; CellStr is not numeric at &quot; + i +  &quot;: &quot; + strValueB );\n    numValueB = 0;\n  }\n  outputNum += numValueB;\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setDataByNumber( dataIdC, new java.math.BigDecimal( outputNum ) );\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADQ0lEQVRYR8WXTUgbQRiGnw3+EBox\nkSJSItGUSsVCUw+CIK0VD3rwDxG8SBUPKwhqLx4UbHsWTDxIDQhaPfZge\/BuoS3FgygVEQtaqqda\nbGKrVAlumV03xs2Pm\/g3IIbdmfmemXnfb76VuOEmJRXfTyPwBAUPEnbAczJ+CYUAEuL\/PF28Nzvv\n+QCT2DmiF+gDNaiZFgB8ZDBKB+J33JYY4DXtWPAmEdgYSATvQOZdPIL4AOP4kNSVX0bzIfM81kSx\nAfxMAc8uI3J4DoUpuugwzhkNYFh5691WRspHsKXbkuJZC6xRNlt2dozCKF2qlsLtLIB25pORHdru\ntTFWMUZWelZSAKu\/Vyl5WxJrTFOkJk4BNLVvGgWnA0hIDC8Ps\/lHdInf6lx1tLhbSAAQIINC3R2n\nAH5eAi+MU+sA4nn3x25mvs1ERa+6U0W9q56QEsKeYafzfmciADH+FbIaj0gAYZnsVAAaXA3U5New\ntb+FO8ttBiCAjOMUQMtws7E21swRWCQLedY8dv7tqCDnHIEeRtWCtgMJPH8FItQAThyhAfiZV3N8\njKYDCBsehA44Vo7VXkKU1jQroeMQR8dH4ZFpUpr6PIEI9b4fkKnUAb4DrkQAugj3jvZwZblY2V1h\n+uk0wu\/Vc9XhoROPJ8xoQPRfQuaRDqDEM1akCwYWBqjNryXflq+6ofdBrwqw8HMBp83J9t9tcq25\nZgFARkoKoO9zH6W3Syl2FDO+Oo633KsCeL96ycnMYfdwl6aCppQATB+BngeE9y90BArLdOExLcJL\nTMUxRGjChsZMeAk7oF5M+g6cm4gEwODCII2Fjar1Fn8tIgQqNCASUVF2EevBdTb2NsxqICIRabng\n3FTc\/6WfZnczzltOVXhDpUOpuiCIrJV3SV1GPZ962A\/tEzgM4Mh0qHVCii6IcRlp17Fww5kL6Qoy\nYZAMCqKvY7EfN1qQ6OYwOEKcd0VeBemW9HjJMuZzkZTmfswZ34W3Xn9xfUUpvEGm3Uh0XWV51MoT\n74D+VitURIkeVSmZPI8g0J7ah4keQXOHKKXFn1kQEVh8mvku9mlmXKbYEYVKJDwo2JF4eFLdLCMR\nQGEJiflEKzavAZN7fNFu\/wFdz58w0loS7gAAAABJRU5ErkJggg==\n\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/11C3mj2uDUv48z_nmHZSW53XE6ploLd6R\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Tsv-String-Sum-of-Number-Column-2021.xml<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Tsv-String-Sum-of-Number-Column-202107.xml (opens in a new tab)\" href=\"https:\/\/drive.google.com\/file\/d\/1KWjAJm28mMViGuoNBnf1yc0ED8NeHXRY\/view?usp=sharing\" target=\"_blank\">Tsv-String-Sum-of-Number-Column-202107.xml<\/a> (Deletes only newline characters at both ends of a string.)<ul><li> \/\/const inputText = (engine.findDataByNumber( dataIdA ) + &#8220;&#8221;).trim();<\/li><li> const inputText = (engine.findDataByNumber( dataIdA ) + &#8220;&#8221;).replace(\/^[\\n]*\/, &#8220;&#8221;).replace(\/[\\n]*$\/, &#8220;&#8221;);<\/li><\/ul><\/li><li><a href=\"https:\/\/drive.google.com\/file\/d\/198Hf-_yRAC55GmWavnZf2VEeDpxvO3Gc\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Tsv-String-Sum-of-Number-Column-20210716.xml<\/a> (Comma removal version: for regions that use a comma as a thousands separator)<ul><li>strValueB = strValueB.replace( \/,\/g, &#8220;&#8221; ); \/\/ 2019-11<\/li><\/ul><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-07-16 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sum-of-number-column-2021\/\">https:\/\/support.questetra.com\/addons\/tsv-string-sum-of-number-column-2021\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Add-on import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Since numeric parsing depends on JavaScript <a rel=\"noreferrer noopener\" aria-label=\"parseFloat() (opens in a new tab)\" href=\"https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseFloat\" target=\"_blank\">parseFloat()<\/a>, numerical values are not recognized if there is a prefix.<\/li><li>The calculation results will differ if the numeric data contains digit separators.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/TSV-String-Sum-of-Number-Column-en.png.png?ssl=1\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"90548\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sum-of-number-column\/attachment\/capture-new-tsv-string-sum-of-number-column-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-TSV-String-Sum-of-Number-Column-en.png?fit=960%2C540&amp;ssl=1\" data-orig-size=\"960,540\" 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=\"capture-new-TSV-String-Sum-of-Number-Column-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-TSV-String-Sum-of-Number-Column-en.png?fit=960%2C540&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/TSV-String-Sum-of-Number-Column-en.png.png?ssl=1\" alt=\"\" class=\"wp-image-90548\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"AovPLvA6hO\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-n-to-number-column-2021\/\">TSV String; Add N to Number Column<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;TSV String; Add N to Number Column&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-add-n-to-number-column-2021\/embed\/#?secret=pUD95ZYO5M#?secret=AovPLvA6hO\" data-secret=\"AovPLvA6hO\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Calculates the sum of values in numeric column. If non-numeric data is mixed in the specified column, the record is regarded as zero and not added.<\/p>\n","protected":false},"author":3,"featured_media":78315,"comment_status":"open","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,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","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":[168],"tags":[389],"faq_section":[],"class_list":["post-109998","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-tsv-csv"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-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":1,"uagb_excerpt":"Calculates the sum of values in numeric column. If non-numeric data is mixed in the specified column, the record is regarded as zero and not added.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-sCa","jetpack-related-posts":[{"id":78314,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sum-of-number-column\/","url_meta":{"origin":109998,"position":0},"title":"TSV String; Sum of Number Column","author":"IMAMURA, Genichi","date":"2019-08-05","format":false,"excerpt":"Calculates the sum of values in numeric column. If non-numeric data is mixed in the specified column, the record is regarded as zero and not added.","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-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\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82429,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-create-cross-tab-for-numerical-sum\/","url_meta":{"origin":109998,"position":1},"title":"TSV String, Create Cross Tab for Numerical Sum","author":"IMAMURA, Genichi","date":"2019-12-05","format":false,"excerpt":"Creates a crosstab (pivot table) for numeric fields in TSV data. For example, the \"Amount\" in the order history (TSV) is aggregated on two axes, \"Responsible\" and \"Product\". The fields for X-axis and Y-axis aggregation are specified by TSV field ID.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Create Cross Tab for Numerical Sum","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Create-Cross-Tab-for-Numerical-Sum-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\/12\/TSV-String-Create-Cross-Tab-for-Numerical-Sum-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Create-Cross-Tab-for-Numerical-Sum-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Create-Cross-Tab-for-Numerical-Sum-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Create-Cross-Tab-for-Numerical-Sum-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":67321,"url":"https:\/\/support.questetra.com\/en\/addons\/googlesheets-sumnumberscom\/","url_meta":{"origin":109998,"position":2},"title":"Sum of cells in a Google Sheets (comma removal version)","author":"Hirotaka NISHI","date":"2016-09-13","format":false,"excerpt":"Stores the sum of specified range of a Google Sheet in a Numeric-type Data Item, and stores its communication log in a String-type Data Item. Comma removal version corresponds to the case where the decimal separator \u201c,\u201d is mixed *Note \u201c+3.14\u201d: 3.14, \u201c314e-2\u201d: 3.14, \u201c090\u201d: 90, \u201c2016-12-23\u201d: 2016, \u2018Begin with\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-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\/2016\/09\/google-sheets-sum-numbers-comma-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":81014,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-values-sum-numbers\/","url_meta":{"origin":109998,"position":3},"title":"Google Sheets: Values, Sum Numbers","author":"IMAMURA, Genichi","date":"2019-10-18","format":false,"excerpt":"Sums the numeric values in the specified range. Values that cannot be recognized as numeric values are regarded as zero. Two ranges of simultaneous calculations are also supported. e.g. The budgeting progress in the general ledger is summarized.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-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\/10\/Google-Sheets-Values-Sum-Numbers-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78324,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-sum-of-number-column\/","url_meta":{"origin":109998,"position":4},"title":"TSV \u6587\u5b57\u5217; \u6570\u5024\u5217\u306e\u7dcf\u548c","author":"IMAMURA, Genichi","date":"2019-08-05","format":false,"excerpt":"\u6570\u5024\u30ab\u30e9\u30e0\u306e\u5024\u306e\u5408\u8a08\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002\u6307\u5b9a\u30ab\u30e9\u30e0\u306b\u6570\u5024\u4ee5\u5916\u306e\u30c7\u30fc\u30bf\u304c\u6df7\u5728\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u5f53\u8a72\u30ec\u30b3\u30fc\u30c9\u306f\u30bc\u30ed\u3068\u307f\u306a\u3055\u308c\u548c\u7b97\u3055\u308c\u307e\u305b\u3093\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"TSV \u6587\u5b57\u5217: \u6570\u5024\u5217\u306e\u7dcf\u548c","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-ja.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\/08\/TSV-String-Sum-of-Number-Column-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":109998,"position":5},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.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\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/TSV-String-Sum-of-Number-Column-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/109998","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=109998"}],"version-history":[{"count":9,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/109998\/revisions"}],"predecessor-version":[{"id":117183,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/109998\/revisions\/117183"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/78315"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=109998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=109998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=109998"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=109998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}