Not Working... Multiple IN Clause for Filter Expression

[sap_cohort]

In my Calc View, I have an Projection Expression Filter with 2 Input Parameters that are configured for Multiple Values. When I execute the Calc View no results get returned. When I remove one of the "IN" Clauses I get results.

It seems like you cannot have more than 1 IN Clause in an Expression Filter!
Can someone try this and let me know if you are able to use more than 1 In Clause in their "Expression Filter"?

in("0CALMONTH", $IP_BPER$)  and 
in("GCONSGRP",  $IP_GCONSGRP$)

We are on HANA 1.0 SPS12

[eralper_yilmaz]

Did you check there are rows validating the two conditions?

[sap_cohort · Accepted solution]

Hi All, Thanks for the views. I was finally able to get it to work.

(in("0CALMONTH", $$IP_BPER$$) or in("0CALMONTH", $$IP_APER$$))  and in("GCONSGRP",$$IP_GCONSGRP$$)

It seems like I tried the same format many times and it failed, but finally, it seemed to work.

Thanks for any feedback!