Showing data 2 criteria - or - different field.

[#1]

Hello

I need help to do follow.

I have a table "attached" with follow field.

• SN ==> Machine SN
• Status ==> indicate if case is "Closed" or "Open"
• Type ==> Indicate type of Service onsite or Travel  : "Site" or "Travel"
• Close_date ==> if case is close we have the date of the case closure
• Service date ==> Date of giving the service "not relvant in this quiery"
• Hours ==> amount of labors done

SN

Status

Type

Close_date

Service_date

hours

I need to have a table showing Only when

• Case is Open ==> Status = Open

Or

• Case is close but Close date is done in the actual Month.

I don't want to do it during the import because I need the all data in different table.

I tried different thing but never succeed.

Thanks

Franck

[#2]

Sorry I attached a wrong file.

and I don't know how to correct this.

attached the correct file

[Anonymous · Accepted solution]

You can use conditions in your expression:
if(Status='Open' OR MonthStart(today())=MonthStart(Close_date))

If you prefer set analysis:
{<Status={'Open'}> + <Close_date={"=MonthStart(today())=MonthStart(Close_date)"}>}

[#4]

Hi Michael

Thank you for your prompt answer. it's working  fine now

Have a good day