1 Reply Latest reply: May 15, 2014 9:56 AM by Data Kruncher RSS

    Custom Calculations

    nikki _

      How can I include custom calculations in my summaries?

       

      For example, I need the (field1's subtotal * 100) / (field2's subtotal).

       

      Thanks!

        • Custom Calculations
          Data Kruncher

          Hi Nikki,

           

          Add field1 as a measure in your summary. You'll see SUM(field1) as the calculation.

           

          Now double click the field1 line in the measures box. This opens a dialog box with three tabs. Click on the Calculation tab. Now click the Edit button and change the formula from SUM(field1) to be:

           

          [font="courier"] (SUM(field1) * 100)/ SUM(field2) /font[/quote]The name of the field will have changed to be RATIO(field). Click the general tab, uncheck the "Use default title" box and give the field a more meaningful name.

           

          HTH,

          Kruncher