As we have a UK Mainland and an International team it's important that we work with the Transactional Currency in some instances. I'm trying to calculate the AvgCostAmount for our International team by using the expression: Sum(AverageCostAmount)*ExchangeRate which works great when only selecting one month however when looking at a period greater than one month it only returns a hyphen.
We work to one budgeted Exchange Rate per month and my assumption is that Qlik isn't liking that there are multiple Exchange Rates when looking at larger periods. Is there an expression that I can use for Qlik to look at the Exchange Rate for each given month when calculating the AvgCostAmountTC?
Sorry Gary, I should've given that information from the get go!
Your first expression is still returning zeros unfortunately however I tried the bottom one and (you're not going to believe this Gary) but moving the bracket seems to have sorted the issue! I'm sure I tried that expression at the beginning when testing and it returned blanks but for whatever reason it's now working perfectly!
