How to set up 2 filter criteria’s on 1 table

Hey @Jacob,

You have to connect the two filters with an OR statement:

FILTER (ORDER_NR = 37 AND DATE < 31-07-2018) OR (DATE = 31-07-2018)

Best,

Justin

Dear Justin,

We tried encoding your example in 3 ways, but none of the 3 works:

CODE:(LEFT(EBELN , 2) = 37 AND AEDAT < <%=startDate%>) OR AEDAT >= <%=startDate%>

FILTER (LEFT(EKKO.EBELN,2) = 37 AND EKKO.AEDAT < <%=startDate%>) OR (EKKO.AEDAT >= <%=startDate%>)

FILTER (EKKO.EBELN LIKE %37% AND EKKO.AEDAT < <%=startDate%>) OR (EKKO.AEDAT >= <%=startDate%>)

The

( ) do not work. Probably make the same reference as startDate, but to a string with left.

I just spoke to Robert about this and het asked me to reply on your email.

Hi @Jacob,

The following should be Code correct:

FILTER (LEFT(EKKO.EBELN,2) = 37 AND EKKO.AEDAT < <%=startDate%>) OR (EKKO.AEDAT >= <%=startDate%>)

Could you please check whether you defined <%=startDate%> correctly? You have to define a Date in the following format: {dyyyy-mm-dd}

Dear Justin,

We also tried this by entering the statement manually but it still gives an error message.:

image006.jpg1117392 39.5 KB

The same when we copy the statement and changed the single quotes around the 37.

Also Vivian asked us to remove the FILTER statement, but also again an error message

image007.jpg1102385 38.7 KB