Set analysis

[MauriceLudo]

Hello,
I would like to know how to translate this rule of management into set analysis: we try to calculate the number of Pdc processed per month
Pdc created the selected month (N°ligne PDC)
Status terminated or canceled (Status)
Different closing date and month of creation (Mois_création, Mois_Cloture)

=count({<  Mois_Création= {'$(=$(vMois_Creation))'}>+<[Statut Prise de contact]={Terminée,Annulée} , Mois_Cloture<>Mois_Creation))'} >} N°Ligne_PDC)

Thank you

Best regards

[vinieme12]

Try below, or post a sample app, it's easier that way Preparing examples for Upload - Reduction and Data Scrambling

=count({<  Mois_Création= {'$(=$(vMois_Creation))'} , [Statut Prise de contact]={'Terminée','Annulée'} , Mois_Cloture = {" = Mois_Cloture <> Mois_Creation"} >} N°Ligne_PDC)

[vishsaggi]

What are the date formats for these two fields ?

Mois_Cloture , Mois_Creation

=count({<  Mois_Création= {"= $(= $(vMois_Creation))"} , [Statut Prise de contact] ={ 'Terminée', 'Annulée' } ,                                   Mois_Cloture = { "<> Mois_Creation" } >} N°Ligne_PDC)

Try this ?

[vishsaggi]

HI Vineeth,

Why do we have these two brackets? They should not be there or is that i am not seeing something?

=count({<  Mois_Création= {'$(=$(vMois_Creation))'} , [Statut Prise de contact]={'Terminée','Annulée'} , Mois_Cloture = {" = Mois_Cloture <> Mois_Creation"))'} >} N°Ligne_PDC)

[vinieme12]

typo

[vishsaggi]

OK cool. 🙂

[MauriceLudo]

Format Date ( janv. févr. , mars)

[vishsaggi]

OK did you try Vineeth's or My expressions? If it doesnt you have to give us more information and expected output you are looking for?

[MauriceLudo]

Hello,
My request is next:
Each request to:    - a date of creation
                              - a date of treatment
                              - a status: processed, completed, canceled, in progress
I take the example of July
A request can be:        - create and process in July
                                    - not created in July processed in July
                                    - created and not processed in July

I am trying to calculate - the number of applications created in July
                              - the number of applications processed in July
                              - the number of applications created and not processed in July
                              - the number processed and not created in July

The number of requests created in july : create in july and close in july ( or closed without date )

=count({<  [Statut Prise de contact] ={ 'Terminée', 'Annulée' } , Mois_Cloture = { "<> Mois_Creation" } >} N°Ligne_PDC)

Attached the July and Juin file