Filtering on specific trade types

[laducd]

Hi Team,

I created a report that is supposed to show me the amount for specific trade types in my database. Please take a look at my attached screenshots for further clarification but essentially here is what I am trying to do: There is one column titled "Exposure Notional" and another titled "Derivative Notional". I would like the "Exposure Notional" column to only display values for trade types titled "Currency Exposure" and the "Derivative Notional" column to only display values for trade types titled "FX Forward". Do you have any thoughts on how to accomplish this type of filtering for each column? I've tried an IF statement but it doesn't actually give me what I'm looking for. Thanks.

Best,

Andy Moncion

[Alex K.]

Hello,

I've tried an IF statement but it doesn't actually give me what I'm looking for.

Could you explain your issue in more details? Also can you please send us your report with test data for analysis.

Thank you.

[HighAley]

Hello, Andy.

Could you specify what are you looking for and what do you get with IIF()?
You could also try to use Conditions and disable the text component if you don't need to show it.
We also need to know which our Designer and what version do you use.
Some features are not available in all our products.

Thank you.