Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum(Aggr(sum(Amount) * Avg(CurrencyRate), OrderNo))
Let me know
thank you but this not works
in your expression, Avg(CurrencyRate) is equal to CurrencyRate
I think we should add some conditions to Avg(CurrencyRate)
could you post your document?
Hi,
did you try with TOTAL Keyword,
Like this,
Avg(TOTAL CurrencyRate)
Regards,
attached an example of data
doesn't work
Here it is my example, let me know
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