AND Custom Filter

grsomer

Hi!

I want to create a custom filter that does the following: 

1) Filters the coloumn TRADE_KEYWORD.BO_ProductType for Cash_Margin & Fees_BBL_ACCR 

and 

2) Filters the column Maturity Date to exclude "June" & Blanks

Is it possible to create a statement that would do this in the custom filter?

Thanks!

LordNeilLord

Hey @grsomer 

I'd personally break this down into multiple filters for easier maintenance but if you did want to do it in one it would be something like:

TRADE_KEYWORD.BO_ProductType in ("Cash_Margin" ,"Fees_BBL_ACCR") 

AND

([Maturity Date] != "June" AND IsEmpty([Maturity Date]))