Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create a dimension which filter the string '10PCMARFINAL' from field [Exposure Type]. I should not use SUM, but when I remove sum, I am getting error. What is the correct syntax?
Give a try with the below: If this doesn't help, then please share a app with sample data and expected output.
=Aggr(Only({<[Exposure Type]={'10PCMARGINAL'}>} [Exposure Type]), Currency,[Discount Curve],[Maturity Bucket].[Trade ID])
Note: you need to list all your dimensions at the end in the above expression.
Try =If(Exposure Type]='10PCMARGINAL', [Exposure Type])
Give a try with the below: If this doesn't help, then please share a app with sample data and expected output.
=Aggr(Only({<[Exposure Type]={'10PCMARGINAL'}>} [Exposure Type]), Currency,[Discount Curve],[Maturity Bucket].[Trade ID])
Note: you need to list all your dimensions at the end in the above expression.