Forum Discussion

jaco1951's avatar
jaco1951
Helper III
8 years ago

Total is wrong when multiplying amount with currency value

Hi all   I have a formula that works on row level, but the total is incorrect.   outgoing_total_USD = [outgoing_total] * MAX(factTable[inverse_CurrencyValue])   Does anyone know how to so...
Show and Tell
jaco1951's avatar
jaco1951
Helper III
8 years ago

Hi Lydia

 

I have studied the example back and forth, and I am not able to recreate it. In my case the total works fine when the currency is the same for the seleceted group. Once I have two currencies, it seems to ignore the calculation of NOKUSD and just show the total as it would be in local currencies, not calculated to USD.

https://www.dropbox.com/s/xk7o5ga9r9yajwe/Data%20for%20currency%20and%20Sum%20Total%20issue.xlsx?dl=0

 

 

 

 

 

 

 

All values in same currency:

 

https://www.dropbox.com/s/3g9a416dzsb2mea/Data%20for%20currency%20and%20Sum%20Total%20issue%20Single%20currency%20works%20fine.xlsx?dl=0

 

Hope this makes it understandable. 

 

Thank you ;-)