1 Reply Latest reply: Jan 8, 2016 8:06 AM by Olly Bond RSS

    Summary Help Please

    April Grimes

      I have a summary created and I want to include an Avg price.

      Is there a way to do that?

      If I add the Avg price field as a Measure it doesn't total correctly.

      If I add it as either an Item or a Key field it won't summarize the items correctly.

       

      HELP!!

        • Re: Summary Help Please
          Olly Bond

          Hello April,

           

          If you have a field in the table and add it as a measure in the summary, then Monarch will just add up all the averages, which, as you spotted, makes very little sense.

           

          I guess your table contains two other fields, Sales and Quantity, from which you have calculated the Average Price on each row of the table?

           

          Then in your summary, if you edit the Measure expression to be Sum(Sales)/Sum(Quantity), you should get more sensible numbers.

           

          Hope this helps,

           

          Olly

           

          Olly Bond

          MONARCH ? | ? | ? | ? EXPERTS

          www.monarchexperts.com<http://www.monarchexperts.com>

          olly@monarchexperts.com<mailto:olly@monarchexperts.com>