Set analysis

alex-wb — Wed, 23 Feb 2022 11:03:58 GMT

Hi All, does anyone know why I get two different results when I use the following codes:

Count({$<
Fault_Closed_Day={">=$(=DATE(Today()-366))"},
Fault_Closed_Day =-{" "},
SLA_Flag= {'N'},
SA_Flag = {'Y'}
>}Fault_Ref)

Count({$<
Fault_Closed_Day={">=$(=DATE(Today()-366))"},
SLA_Flag= {'N'},
SA_Flag = {'Y'}
>}Fault_Ref)

I though the code would give the same results since the first one is saying the fault closed date must be greater than or equal to 366 days ago and not blank, the second one says that but without the not blank part.

Re: Set analysis

anvalo00 — Wed, 23 Feb 2022 11:11:53 GMT

Hola,

Cuentan cosas distintas (Ref_fallo o Fault_Ref)

Saludos,

topic Set analysis in App Development

Set analysis

Re: Set analysis