Month to Month comparison

[Anonymous]

Hi All,

I need to compare month to month data and calculate the difference between the current and the prior month :

Code           |               Period                        |        Sales         | Diff

----------------------------------------------------------------------------------------

11                |               201801                      |      2100            |    0

11                |               201802                      |      1800            |    -300

11                |               201803                      |      2600            |    800

11                |               201804                      |      1100            |    -500

11                |               201805                      |      4100            |    3000

11                |               201806                      |      6100            |    2000

I created those expressions but it doesn't work:

sum({<[Calendar Year/Month] = {"$(=Date(Addmonths([Calendar Year/Month],-1),'YYYYMM'))"}>} RB)

Can anyone help please ?

thanks

[zebhashmi]

try that

sum({<[Calendar Year/Month] = {">=$(=Date(Addmonths([Calendar Year/Month],-1),'YYYYMM'))<=$(=Date([Calendar Year/Month]),'YYYYMM'))"}>} RB)

[sunny_talwar · Accepted solution]

Try this

Alt(Sum(RB) - Above(Sum(RB)), 0)

or

Alt(Sum(RB) - Above(TOTAL Sum(RB)), 0)

[Anonymous]

Hi,

thanks for the response but unfortnately it doesn't return any result.

[Anonymous]

Hi,

Thanks for your response.

it works