Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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