1 Reply Latest reply: May 15, 2014 10:03 AM by Data Kruncher RSS

    Total Percents in Summaries

    ARICE01 _

      I am sure I have done this before, but I can remember how:  I am calculating a Percent of two numerical fields and showing all three numbers on my summary.  I want the grand total to show the sum for the two fields (F1 and F2) and the overall percent for Total F1/ Total F2. But Monarch V10.0 only gives me the options to show the sum of all the individual percents which is not what I want.

       

      Please help. Thanks,

        • Total Percents in Summaries
          Data Kruncher

          First add another instance of F2 to the measures list. Now double-click the second F2.

           

          On the Calculation tab, click the Edit button and make the expression:

           

          SUM(F1)/SUM(F2)[/CODE]

           

          Finally, on the General tab, uncheck the "Use default title" box and supply a more meaningful name.

           

          HTH,

          Kruncher