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 · Accepted solution]

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]))

[danilang]

hi @grsomer 

This should you for you

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

and 

[Maturity Date] != "June"

AND 

!isempty([Maturity Date])

Dan