Sum(if Year problem

[laupama]

Hi,

I have a problem with a sum if condition.

If i just take Months it works:

=sum(IF([Llamadas.Dia.autoCalendar.Month]=(Month(AddMonths(today(),-1))),Recibidas))

If i take Years it doesn't work:

=sum(IF([Llamadas.Dia.autoCalendar.Year]=(Year(AddMonths(today(),-1))),Recibidas))

I don't know why it's working like this.

I take an screenshoot with booth conditions, and the result of "[Llamadas.Dia.autoCalendar.Year]" and "(Year(AddMonths(today(),-1))"

[Lisa_P · Accepted solution]

Use set analysis:

=sum({<[Llamadas.Dia.autoCalendar.Month]={$(=Month(AddMonths(today(),-1))}>}Recibidas)

=sum({<[Llamadas.Dia.autoCalendar.Year]={$(=Year(AddMonths(today(),-1))}>}Recibidas)

[laupama]

Hi Lisa_P,

it works!

Thank you so much.

Finally I have booth conditions working: 

=sum({<[Llamadas.Dia.autoCalendar.Year]={$(=Year(AddMonths(today(),-1)))},[Llamadas.Dia.autoCalendar.Month]={$(=Month(AddMonths(today(),-1)))}>}Recibidas)