Calculated Average Dimension

[bazzaonline]

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???

[anbu1984]

Check this

[bazzaonline]

??  What ??

[wernerprovelu]

Or use set analysis:

Avg({<Amt = -{25}>} Amt)

[anbu1984]

There is prob in community. I attached qvw in my previous post which I can see it.

Re-attaching qvw

[jyothish8807]

Hi Paul,

Go to presentation tab.In reference line option add two expression.

1. Avg(Amt)

2 Avg({Amt-={'25'}>}Amt)

Regards

KC