Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Can anyone help me in converting this expression to Set Analysis
sum(aggr(If([Currency]='Transactional' and [Dummy1]='Y' ,[Price List],
If
([Currency]='Functional' and [Dummy1]='Y',
[Price List] * max(if([Revenue Schedule Type]='RPRO-COGS',
[EX Rate]),
0
),
([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]))