Help in set_analisys formula

[gamaplast]

Hi,

I have to build an expression in set_analisys which sums the values of a reference year from Jan to a reference month; reference year and reference month are stored in two variables.

It should be something like that:

=Sum( {$<AnnoReg = {$(RefYear)}, MeseRegNum = {"=<$(RefMonth)"}>} Values)

Should someone help me with the syntax formula, please?

Thks.

R.

[Colin-Albert · Accepted solution]

Try this

=Sum( {$ <AnnoReg = {$(RefYear)}, MeseRegNum = {"<=$(RefMonth)"}>} Values)

[gamaplast]

Thank you, Albert,

it was only a little (but very important) switch!! 😉

C u soon for next help... 🙂

R.