Expression convert to Load script become not working ?

[paulyeo11]

Hi All

I have a load script which i mark // which is not working.

sales:
LOAD
'PMC' as SOURCE,
[Row Total],
[Price Currency],
[Price Currency] as CURRENCY,
// Sum([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) as sales,
Quantity AS [quantity],
[Manufacturer Name (Brand)] AS BRAND_RAW,
[Manufacturer Name (Brand)] AS BRAND_,
Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/YY/YYY') as [date],
[Product Code] AS PRO_CLASS

FROM
[C:\Users\Paul Yeo\Dropbox\QLIK_SAP\DEVELOPMENT_QV\ask\TDS.xlsx]
(ooxml, embedded labels, table is TDS);

When i apply below expression at Table 1 it work fine :-
Sum([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

Hope some one can share with me where go wrong ?

Paul Yeo

[paulyeo11]

Hi All Enclosed my QVW for your ref.

[Vegar · Accepted solution]

Sum() is an aggregatet function and you will need to point out over which dimensions you want to do the aggregation with a GROUP  BY .

I suspect that you don't need the sum. Try this instead:

[Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1) as Sales,

[paulyeo11]

Hi Sir

thsnk you very much it work now

[Vegar]

Thats sounds great.

Glad to help.