SUM TOTAL and AVG

[#1]

Dear all,

I need a solution for my problem. I want to use the totals of the tables below for further calculations.

There must be a solution, but I couldn't find it. I tried AGGR, sum(total <field>), but without result.

Order 960 has 5 codes of 30 and order 961 has 1 code of 30.

I need the following figures:

- Total Orderbedrag = 180

- Avg Orderbedrag = 90

- Avg Bonbedrag = 30

Can you help me with this?

Kind regards,

Erwin

[MK_QSL]

Can you share your sample data please?

[#3]

Can you share a sample app with small data?

[#4]

Hi Manish and Shyamal,

This comes from my DB, so I do not have sample data. Or can I export this to excel?

kind regards,

Erwin

[MK_QSL]

Just give us few lines in excel...

[#6]

Hi All,

I will add two xls files. Kind regards, Erwin

[MK_QSL]

SUM([Order Amount])

SUM(TOTAL [Order Amount])/COUNT(TOTAL DISTINCT OrderId)

or

SUM([Order Amount])/COUNT(DISTINCT OrderId)

Dont have idea about

Avg Bonbedrag = 30

[#8]

Hi Manish,

This does not seem to work.

below the results of your expressions:

[MK_QSL]

What is the dimension you are using?

[#10]

It doens't matter if I use orderId or codeId.

the sum total stays the same.