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

marieclaire — Mon, 28 Sep 2015 20:24:44 GMT

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)

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

marieclaire — Fri, 02 Oct 2015 11:58:55 GMT

I can close this message.

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