set analysis (sum, avg, aggregation...)

[#1]

Hi all,

I have a list of orders like the following :

Order ID	Amount	Currency	Currency Rate	Order Date

I need to show, in a text box, the sum of all Amount in Euro where :

sum of all Amount in Euro =sum of all orders and for every Order: sum(Amount) * the average of Currency Rate of the current Currency.

that means, the average of Currency is calculated based on all other order having the same currency

any idea ?

Regards,

Yacine

[alexandros17]

Try this

Sum(Aggr(sum(Amount) * Avg(CurrencyRate), OrderNo))

Let me know

[#3]

thank you but this not works

in your expression, Avg(CurrencyRate) is equal to CurrencyRate

[#4]

I think we should add some conditions to Avg(CurrencyRate)

[alexandros17]

could you post your document?

[PrashantSangle]

Hi,

did you try with TOTAL Keyword,

Like this,

Avg(TOTAL CurrencyRate)

Regards,

[#7]

attached an example of data

[#8]

doesn't work

[alexandros17]

Here it is my example, let me know

[#10]

thank you but this is not what I want. for this example, we should have 1 currency rate for CHF and 1 currency rate for BRL (for all the data). then, we have to divide every order amount by the currency rate