How to write a current month / previous month (or year) expression ?

[marieclaire]

Hello,

I try to calculate the evolution of monthly audience (based on a selection date)

vs the previous month (M-1)

and vs  the previous year (A-1).

I tried to use these expressions, but it doesn't work.

(

(sum( {$<Mois = {$(=Max (Mois))}>} [m_visits]))-(sum( {$<Mois = {$(=Max (Mois)-1)}>} [m_visits])))

/sum( {$<Mois = {$(=Max (Mois)-1)}>} [m_visits])

( {$<Mois = {$(=Max (Mois))}>} [m_visits]) - ( {$<Mois = {$(=Max (Mois)-1)}>}  [m_visits]))

/( {$<Mois = {$(=Max (Mois)-1)}>}  [m_visits])

( {$<Année = {$(=Max (Année))}>}  [m_visits]) - (sum( {$<Année = {$(=Max (Année)-1)}>}  [m_visits] ))

/( {$<Année = {$(=Max (Année)-1)}>} [m_visits])

Anybody could help me ?

Thank you,

See attached file (August 2015)

[marieclaire]

I can close this message.

The expression was good. The problem came from the format of month.