Conversion of this expression into Set

Wed, 19 Feb 2014 00:07:57 GMT

Hello

Can anyone help me in converting this expression to Set Analysis

sum(aggr(If([Currency]='Transactional' and [Dummy1]='Y' ,[Price List],

([Currency]='Functional' and [Dummy1]='Y',

[Price List] * max(if([Revenue Schedule Type]='RPRO-COGS',

[EX Rate]),

([Currency]='Reporting' and [Dummy1]='Y',

([Price List] * max(if([Revenue Schedule Type]='RPRO-COGS',[EX Rate]),0)) *

max(if([Revenue Schedule Type]='RPRO-COGS',[Reporting Currency Ex Rate]),0)

)

,[Transaction ID]))

topic Conversion of this expression into Set in QlikView