{"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":"

What is the \u2018Sum-Up\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

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>\n

 <\/p>\n

How to use the \u2018Sum-Up\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

 <\/p>\n

The important fields in the \u2018Sum-Up\u2019 task are<\/p>\n

    \n
  1. Select Table<\/strong><\/li>\n<\/ol>\n

    Use this dropdown menu to select the table in which you would like to apply a formula.<\/p>\n

     <\/p>\n

      \n
    1. Column<\/strong><\/li>\n<\/ol>\n

      Use this dropdown menu to select the column on which you would like to carry out the calculation.<\/p>\n

       <\/p>\n

        \n
      1. Action<\/strong><\/li>\n<\/ol>\n

        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>\n

          \n
        1. Output Column Name<\/strong><\/li>\n<\/ol>\n

          Use this field to type in the name of the new column, which will house the calculated values.<\/p>\n

           <\/p>\n

            \n
          1. Format<\/strong><\/li>\n<\/ol>\n

            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>\n

             <\/p>\n

            How to use the \u2018Define Output Table\u2019 and the \u2018Output Options\u2019 sections in the \u2018Sum-Up\u2019 task?<\/strong><\/p>\n

            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

            More information about this section is available here<\/a><\/strong><\/em>.<\/p>\n

             <\/p>\n

             <\/p>\n