This content has been marked as final. Show 5 replies
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???