sum with a concatenation of 2 fields

[#1]

Hi guys,

I need help about a sum with a concatenation of 2 fields.

I have to Sum my budget for a specific Year (max year) and for a specific month.

Now I have this expression:

sum({$<YEAR={$(=max(YEAR))}>}Budget)

and it works perfectly.

So, i tried to add the new field in my expression and I wrote:

sum({YEAR ={$(=max(YEAR))},Month={$(=Only(Month))}}Budget)

Unfortunately I made a mistake in somewhere and I can't try if my expression is correct or no.

What's wrong in my expression ?

Thanks a lot

[#2 · Accepted solution]

The '<' & '>' are missing in your expression. Check if the following works:

sum({<YEAR ={$(=max(YEAR))},Month={$(=Only(Month))}>}Budget)

[#3]

Thanks a lot it works.

Too concentrate to other things and I didn't see the obvious.

Again, Thanks.