5 Replies Latest reply: Oct 6, 2014 10:44 AM by Jyothish KC RSS

    Calculated Average Dimension

    Paul Barrett

      Hello All,

       

      I would like to draw a graph which has two average lines on.  One a simply average invoice amount per month - eg =Avg(InvoiceAmount)

       

      The second I want to be the average invoice amount except for ones of £25.  (so to not include invoices for a £25 fee only).

       

      EG - Invoice 1 - £100, Invoice 2 - £80, Invoice 3 - £25 = ( £100 + £80 ) / 2 = £90.

       

      Any help welcomed???