4 Replies Latest reply: May 15, 2014 9:56 AM by Grant Perkins RSS

    Sum

    OJGraf _

      Hello, I'm searching for the sum (like in excel e.g. =Sum(a1:A8)

       

      Is there a equal function ?

       

      greetings oli

        • Sum
          Steve Caiels

          Hi Oli,

           

          Not exactly!!

           

          If you want to add numeric columns in a table, create a formula based calculated field and use the expression field1field2field3+field4   etc etc. . .

           

          If you want to add down the page, you’ll need to create a summary.  You can add subtotals by double clicking on the key field and use the options in the display tab.

           

          I hope this quick answer helps out a bit.  If you want more details, just ask.

           

          Regards

          Steve

          • Sum
            OJGraf _

            Hi Steve,

            I want to make a summary horizontal:

             

            A B C D

            1

            2

            3

             

            In Excel I can use: Sum(A1:D1). What can I do in Monarch ?

             

            greetings Oli

            • Sum
              Nick Osdale-Popa

              In that example, you'd make a calculated field and put in the following equation:

               

              ABC+D

               

              You would get the sum of those four fields for every row.

              • Sum
                Grant Perkins

                Originally posted by OJGraf:

                Hi Steve,

                I want to make a summary horizontal:

                 

                A B C D

                1

                2

                3

                 

                In Excel I can use: Sum(A1:D1). What can I do in Monarch ?

                 

                greetings Oli /b[/quote]Oli,

                 

                If the A, B, C, D columns represent different values of the same field you could set the field to display ACROSS in the summary and then select the count format/method(s) that you wish to report. This will enable both horizontal and vertical summation.

                 

                If the columns do not currently represent values of the same field it may be possible to make a 2 stage process in Monarch where the first stage re-groups the data to make the analysis possible by the second part of the process.

                 

                Apoligies if I have not understood your requirements correctly.

                 

                 

                Grant