{"id":521,"date":"2021-05-22T12:16:25","date_gmt":"2021-05-22T12:16:25","guid":{"rendered":"https:\/\/support.zippydoc.de\/?p=521"},"modified":"2022-04-23T08:40:52","modified_gmt":"2022-04-23T08:40:52","slug":"add-row","status":"publish","type":"post","link":"https:\/\/support.zippydoc.de\/en\/add-row\/","title":{"rendered":"Add Row"},"content":{"rendered":"

What is the \u2018Add Row\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

The \u2018Add Row\u2019 task can be used to append a new row to a data table. The row can contain numerical calculations.<\/p>\n

 <\/p>\n

 <\/p>\n

How to use the \u2018Add Row\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

 <\/p>\n

The important fields in the \u2018Add Row\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 add a row.<\/p>\n

     <\/p>\n

      \n
    1. Columns to apply<\/strong><\/li>\n<\/ol>\n

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

       <\/p>\n

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

        Use this dropdown to select the position of the new row. It can either be above, or below, or interspersed throughout the selection.<\/p>\n

         <\/p>\n

          \n
        1. New Row Name<\/strong><\/li>\n<\/ol>\n

          Use this field to type in the name of the new row in the output table.<\/p>\n

           <\/p>\n

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

            Use this dropdown menu to select the calculation type in the new row.<\/p>\n

             <\/p>\n

              \n
            1. Select Row(s)<\/strong><\/li>\n<\/ol>\n

              Use this dropdown menu to select the rows on which the function will act.<\/p>\n

               <\/p>\n

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

                Use this dropdown to refine the position of the new row. You can select to position it above or below a row or segment of rows.<\/p>\n

                 <\/p>\n

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

                  Use this dropdown menu to indicate the format of the new row. 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 \u2018Add Row\u2019 task?<\/strong><\/p>\n

                  The \u2018Output Options\u2019 section in the \u2018Add Row\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