Problem with set analysis last year

[#1]

Hello,

I am trying to put a set analysis last year with to selections and it misses.

Sum ({<Año={$(AñoActual) -1}  , Mes={$(MesActual)}>} IMPORTE2)

The actual comma separating Año and Mes (Year and Month) is detected wrong.

Need help is for the job, thank you!

[marcus_sommer]

It's probably a format-issue. Try something like this:

Mes={'$(MesActual)'} or Mes={$(=num($(MesActual))} or Mes={MesActual}

- Marcus

[marthacano01 · Accepted solution]

Hi Ciro.

Try this:

Sum ({<Año={$(=$(AñoActua) -1)}  , Mes={$(MesActual)}>} IMPORTE2)

[#4]

Works like a charm.

Thank you very much!