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
parry2k's avatar
parry2k
Super User
8 years ago

You have to use SUMX for your calculation.

jaco1951's avatar
jaco1951
Helper III
8 years ago

Thanks, that was a good suggestion, but it doesn't solve the problem. Still not correct sum.