Set analysis

[maxime66]

Hi !

I would like to get  ( in the Blue text box of the Qkw file joined ),the sum(CA1)  for January 2014 (100 €).

This box must report for each month of  "Date_ca" the sum(CA1) for the previous year (don't know if very clear )

Thanks for your time.

[Anonymous]

Hi Maxime, try this:

=sum( {1 <annee_mois={ "$(=left(Date_ca,4)-1 & '/' & $(=mid(Date_ca,5,2) ) )"} > } CA1)

[reshmakala]

Find attached solution

[Anonymous · Accepted solution]

This is correct, but why don't use date formatting functions instead of string functions.  It is much easier:

=sum( {1 <annee_mois={ "$(=date(addyears(date#(Date_ca,'YYYYMMDD'),-1),'YYYY/MM'))"} > } CA1)

[maxime66]

Thanks Michael,  Works perfectly !

You're right, date formatting is better !

++

[Anonymous]

Hello maxime66, please close the thread selecting what answer was helpful or the solution, in order to help the rest of users to search threads with correct answers.

Thank you.