Skip to Content

Not Working... Multiple IN Clause for Filter Expression

Jan 17 at 04:11 AM


avatar image

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 

We are on HANA 1.0 SPS12

10 |10000 characters needed characters left characters exceeded

Did you check there are rows validating the two conditions?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kenneth Murray Jan 17 at 03:34 PM

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!

10 |10000 characters needed characters left characters exceeded