Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends
We have some fields like Amount, rate and tax_amount in different currencies. If we multiply amount and tax_amount with rate
we get the corresponding amount in local currency.
We are doing this in script itself as sum(Amount) * rate and sum(tax_amount) * rate.
We are then taking group by of the remaining dimensions. However we are not getting the correct data for all transactions.
We also tried amount * rate but it is giving incorrect data.
Kindly help if you have any suggestions. Thanks in advance.
Thanks & Regards
Chintan
Hi Chintan,
Could you share some example of your data and app please?
Regards!
Give something like this a try: sum(Amount * rate)
- Marcus
It will be nice if you share some sample data, so that we can take a look and come up with a solution.