Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
=Sum( {$ <AnnoReg = {$(RefYear)}, MeseRegNum = {"<=$(RefMonth)"}>} Values)
Try this
=Sum( {$ <AnnoReg = {$(RefYear)}, MeseRegNum = {"<=$(RefMonth)"}>} Values)
Thank you, Albert,
it was only a little (but very important) switch!! 😉
C u soon for next help... 🙂
R.