Solved: Sum if with month(today()) not working

[Gerard]

HI All,

I'm not getting this formula to work:

Sum({<
[Period date year] = {"$(=year(AddMonths(today(), -1)))"},
[Period] = {"$(=month(today()))"}
>} [Amount in EUR])

This however is working:

Sum({<
[Period date year] = {"$(=year(AddMonths(today(), -1)))"},
[Period] = {3}
>} [Amount in EUR])

Where I replaced the month formula with 3. When I do months(today()) in a seperate formula it returns 3 as expected.

So I'm puzzled.... Does anyone understand why this is not working ?

Thanks for your time !

Gerard

[Taoufiq_Zarra · Accepted solution]

and if you test :

Sum({<
[Period date year] = {"$(=year(AddMonths(today(), -1)))"},
[Period] = {"$(=num(month(today())))"}
>} [Amount in EUR])

?

[Gerard]

Thanks Taoufiq ! This did the trick.

Much appreciated !

[NitinK7]

Hi Gerard,

try following Expression

it will working.

Sum({<
[Period date year] = {"$(=Year(AddMonths(today(), -1)))"},
[Period] = {"$(=Num(Month(today())))"}
>} [Amount in EUR])

regards,

Nitin.