issue in calculation in script

[Anonymous]

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

[Anonymous]

Hi Chintan,

Could you share some example of your data and app please?

Regards!

[marcus_sommer]

Give something like this a try: sum(Amount * rate)

- Marcus

[trdandamudi]

It will be nice if you share some sample data, so that we can take a look and come up with a solution.