Skip to Content

Not Working... Multiple IN Clause for Filter Expression

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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!

    Add comment
    10|10000 characters needed characters exceeded