Hello, I need your help with a formula. Im ...

(Sebban Jonathan) #1

Hello, I need your help with a formula.

Im trying to get all the value from another table and next count how many they are for a year.

I added a virtual column [Selection CP] (list) :

=SELECT(Rapport Client[Date entretien :], LEFT([code postal :], 2) = [_THISROW].[Dept], [Date entretien :]>“01/01/2017”)

and another [Nbr Rapport CP] (number) to count the previous virtual column :

=COUNT([Selection CP])

But i get all the value, not only the one who was made after 01/01/2017

Could you help me please?

thank you

(Sebban Jonathan) #2

OK i found the solution sorry, just need to add fonction : AND

=SELECT(Rapport Client[Date entretien :], AND(LEFT([code postal :], 2) = [_THISROW].[Dept], [Date entretien :]>“01/01/2017”)) Translate