Calculation Help (Qlik Sense)

[fcecconi]

Hello

I am trying to create a summary table of revenue values my company codes for the year.  The revenue needs to be converted to USD.  When I leave the individual currency lookup key in the table, I get the correct value.  However when I remove the lookup key, the value will not calculated.

thanks in advance for your help

Frank

[lironbaram]

can you post your expression and dimensions of the table

[fcecconi]

The calculation is (Sum([Amount in doc. curr.])*[Actual Rate])/1000

There is a join from the fact to the exchange rate table (Currency Lookup column)

[lironbaram · Accepted solution]

those your dimension has multiple records of [Actual Rate]

if so you'll need to use an aggr expression something like:

sum(aggr((Sum([Amount in doc. curr.])*[Actual Rate])/1000,currency_key,Yourdimensions))

[maxgro]

Sum([Amount in doc. curr.]*[Actual Rate])   / 1000

[fcecconi]

Liron

thanks.  Here is what the calculation ended up:

sum(aggr((Sum([Amount in doc. curr.])*[Actual Rate])/1000,[Currency lookup],[Currency Code],

[Fiscal year],[Company Code]))*-1