Remove max and aggr from the given set expression

Thu, 20 Feb 2014 00:25:30 GMT

Hello

I am trying to remove max and aggr from the below set expression but getting syntax errors. Please advise

sum(aggr(pick(match([Currency],'Transactional','Functional','Reporting') ,[Sell Price],

[Sell Price] * max({<[Revenue Schedule Type]= {'RPRO-REVENUE'}>} [Trans Exchange Rate]),

[Sell Price] * max({<[Revenue Schedule Type]= {'RPRO-REVENUE'}>} [Trans Exchange Rate]) *

max({<[Revenue Schedule Type]= {'RPRO-REVENUE'}>} [Trans Reporting Exchange Rate]) ),[Transaction ID]))

Thanks

topic Remove max and aggr from the given set expression in QlikView