1 Reply Latest reply: May 15, 2014 10:02 AM by Grant Perkins RSS

    Averages - Help :)

    Jeanette Lea

      Can any of you wonderful (creep, creep) Monarch gurus help me please.........

      I have a list of values that I need to average, they appear in the table as :

      Inv_no      Value

      I0003079        £  45.00-

      I0003079             0.00

      I0003079             0.00

      I0003079             0.00

      I0003079        £724.60

      I0003086        £248.00

      I0003086        £776.00

      I0003086             0.00

      I0003086       £1552.00

      I0003086             0.00

      I0003086             0.00

      I0003086             0.00

      I0003086        £257.60

      I0003057      £3650.00

       

      I need an average of the total of the invoice values ie :

      Inv_No       Inv Total

      I0003079    £679.60

      I0003086  £2833.60

      I0003057  £3650.00

       

      Average   £2387.73 ((£679.60£2833.60£3650)/3)

       

      I can get the Invoice Totals in a straightforward summary, is there anyway I can get the averages of these totals within the same model rather than exporting the total summary and reopening as a table to average as an additional model?

        • Averages - Help :)
          Grant Perkins

          Hi Jeanette and welcome to the forum.

           

          If your data is presented just as you posted I think yor options are limited to your own suggestion. Export and analyse that report. You could make the process a single batch file driven operation.

           

          On the other hand if you have any way of setting a Page Header such that eaich I number has its own virtual page you could use max() in a formula for a measure :

           

          sum(money_field)/max(page#)

           

          but ONLY if the total number of lines for a single I number is less than 256 (or what ever the max number of lines for a page is set to.)

           

          If it were my task I might choose either approach depending on the full circumstances and the opportunity to identify the virtual page break.

           

          HTH.

           

           

          Grant