Pentaho

 View Only

 How to use the IN function in Report Designer

  • Pentaho
  • Pentaho
Gerald Mollineau's profile image
Gerald Mollineau posted 10-04-2021 15:45

Hi

 

I see there is a function "IN" in Report Designer formula editor.

It gives an error when I try to use the SQL syntax:

 

IF([COMPANY_ID], IN ("SSC", "UFLC"), Test=1;)

 

I am unsble to locate any instructions for this function.

 

Can Anyone help.

 

regards

 

Gerald