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!
Solved! Go to 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]))
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
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |