{"id":543,"date":"2021-05-22T12:46:58","date_gmt":"2021-05-22T12:46:58","guid":{"rendered":"https:\/\/support.zippydoc.de\/?p=543"},"modified":"2021-06-15T14:07:00","modified_gmt":"2021-06-15T14:07:00","slug":"sum-up","status":"publish","type":"post","link":"https:\/\/support.zippydoc.de\/en\/sum-up\/","title":{"rendered":"Sum-Up"},"content":{"rendered":"<p><strong>What is the \u2018Sum-Up\u2019 task?<\/strong><\/p>\n<p><img class=\"aligncenter wp-image-671 size-full\" src=\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Sum-Up-Pictogram-e1621711982972.png\" alt=\"\" width=\"869\" height=\"150\" \/><\/p>\n<p>The \u2018Sum-Up\u2019 task can be used to apply a wide range of mathematical and statistical functions to a dataset. It is a useful tool to carry out numerical, statistical, and even text calculations, or to group data ranges together.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>How to use the \u2018Sum-Up\u2019 task?<\/strong><\/p>\n<p><img class=\"aligncenter wp-image-544 size-full\" src=\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Sum-Up-e1621687602101.png\" alt=\"\" width=\"500\" height=\"439\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>The important fields in the \u2018Sum-Up\u2019 task are<\/p>\n<ol>\n<li><strong>Select Table<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this dropdown menu to select the table in which you would like to apply a formula.<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"2\">\n<li><strong>Column<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this dropdown menu to select the column on which you would like to carry out the calculation.<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"3\">\n<li><strong>Action<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this dropdown menu to select the type of calculation you would like to carry out. You can either select a numerical or text calculation, or choose to group values together.<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"4\">\n<li><strong>Output Column Name<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this field to type in the name of the new column, which will house the calculated values.<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"5\">\n<li><strong>Format<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this dropdown menu to indicate the format of the calculated values. You may select a numerical, or date, or currency, or text format.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>How to use the \u2018Define Output Table\u2019 and the \u2018Output Options\u2019 sections in the \u2018Sum-Up\u2019 task?<\/strong><\/p>\n<p>The \u2018Output Options\u2019 section in the \u2018Sum-Up\u2019 task can be used to modify features of the output table. The fields related to this section become visible on selecting the \u2018Output Options\u2019 checkbox.<\/p>\n<p>More information about this section is available <em><strong><a href=\"https:\/\/support.zippydoc.de\/output-table-options\/output-options\/output-options\/\">here<\/a><\/strong><\/em>.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/4_7aqeFVlJ4\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The \u2018Sum-Up\u2019 task can be used to apply a wide range of mathematical and statistical functions to a dataset. It is a useful tool to carry out numerical, statistical, and even text calculations, or to group data ranges together.<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[160],"tags":[195,186,188,196,187,185,200,197,198,199,201,194,193,33],"featured_image_src":{"landsacpe":false,"list":false,"medium":false,"full":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sum-Up - Zippydoc Support<\/title>\n<meta name=\"description\" content=\"The \u2018Sum-Up\u2019 task can be used to apply a wide range of mathematical and statistical functions to a dataset. It is a useful tool to carry out numerical, statistical, and even text calculations, or to group data ranges together.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/support.zippydoc.de\/en\/sum-up\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sum-Up - Zippydoc Support\" \/>\n<meta property=\"og:description\" content=\"The \u2018Sum-Up\u2019 task can be used to apply a wide range of mathematical and statistical functions to a dataset. It is a useful tool to carry out numerical, statistical, and even text calculations, or to group data ranges together.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.zippydoc.de\/en\/sum-up\/\" \/>\n<meta property=\"og:site_name\" content=\"Zippydoc Support\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-22T12:46:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-15T14:07:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Sum-Up-Pictogram-e1621711982972.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tejas Valake\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/#website\",\"url\":\"https:\/\/support.zippydoc.de\/en\/\",\"name\":\"Zippydoc Support\",\"description\":\"Connect as if by magic\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/support.zippydoc.de\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/sum-up\/#primaryimage\",\"url\":\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Sum-Up-Pictogram-e1621711982972.png\",\"contentUrl\":\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Sum-Up-Pictogram-e1621711982972.png\",\"width\":869,\"height\":150},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/sum-up\/#webpage\",\"url\":\"https:\/\/support.zippydoc.de\/en\/sum-up\/\",\"name\":\"Sum-Up - Zippydoc Support\",\"isPartOf\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/sum-up\/#primaryimage\"},\"datePublished\":\"2021-05-22T12:46:58+00:00\",\"dateModified\":\"2021-06-15T14:07:00+00:00\",\"author\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946\"},\"description\":\"The \u2018Sum-Up\u2019 task can be used to apply a wide range of mathematical and statistical functions to a dataset. It is a useful tool to carry out numerical, statistical, and even text calculations, or to group data ranges together.\",\"breadcrumb\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/sum-up\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.zippydoc.de\/en\/sum-up\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/sum-up\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.zippydoc.de\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sum-Up\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946\",\"name\":\"Tejas Valake\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g\",\"caption\":\"Tejas Valake\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sum-Up - Zippydoc Support","description":"The \u2018Sum-Up\u2019 task can be used to apply a wide range of mathematical and statistical functions to a dataset. It is a useful tool to carry out numerical, statistical, and even text calculations, or to group data ranges together.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/support.zippydoc.de\/en\/sum-up\/","og_locale":"en_US","og_type":"article","og_title":"Sum-Up - Zippydoc Support","og_description":"The \u2018Sum-Up\u2019 task can be used to apply a wide range of mathematical and statistical functions to a dataset. It is a useful tool to carry out numerical, statistical, and even text calculations, or to group data ranges together.","og_url":"https:\/\/support.zippydoc.de\/en\/sum-up\/","og_site_name":"Zippydoc Support","article_published_time":"2021-05-22T12:46:58+00:00","article_modified_time":"2021-06-15T14:07:00+00:00","og_image":[{"url":"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Sum-Up-Pictogram-e1621711982972.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tejas Valake","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/support.zippydoc.de\/en\/#website","url":"https:\/\/support.zippydoc.de\/en\/","name":"Zippydoc Support","description":"Connect as if by magic","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.zippydoc.de\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.zippydoc.de\/en\/sum-up\/#primaryimage","url":"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Sum-Up-Pictogram-e1621711982972.png","contentUrl":"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Sum-Up-Pictogram-e1621711982972.png","width":869,"height":150},{"@type":"WebPage","@id":"https:\/\/support.zippydoc.de\/en\/sum-up\/#webpage","url":"https:\/\/support.zippydoc.de\/en\/sum-up\/","name":"Sum-Up - Zippydoc Support","isPartOf":{"@id":"https:\/\/support.zippydoc.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.zippydoc.de\/en\/sum-up\/#primaryimage"},"datePublished":"2021-05-22T12:46:58+00:00","dateModified":"2021-06-15T14:07:00+00:00","author":{"@id":"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946"},"description":"The \u2018Sum-Up\u2019 task can be used to apply a wide range of mathematical and statistical functions to a dataset. It is a useful tool to carry out numerical, statistical, and even text calculations, or to group data ranges together.","breadcrumb":{"@id":"https:\/\/support.zippydoc.de\/en\/sum-up\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.zippydoc.de\/en\/sum-up\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/support.zippydoc.de\/en\/sum-up\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.zippydoc.de\/en\/"},{"@type":"ListItem","position":2,"name":"Sum-Up"}]},{"@type":"Person","@id":"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946","name":"Tejas Valake","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g","caption":"Tejas Valake"}}]}},"_links":{"self":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/posts\/543"}],"collection":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/comments?post=543"}],"version-history":[{"count":0,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/posts\/543\/revisions"}],"wp:attachment":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/media?parent=543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/categories?post=543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/tags?post=543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}