# work out growth vs market growth

**Louwrie Terblanche**Jul 31, 2012 3:57 PM

Hi ,

I would appreciate help with the following.

I need to calculate

the growth of products against the average growth of the amount of products

that has values both for this year MAT and the preious YEAR MAT. I NEED TO IGNORE PRODUCTS WHO DOESN’T HAVE

VALUES IN BOTH OR EITHER IN ONE.

I have total sales figures for products on MAT for 2 years.

First I calculate the growth per product against the previous year’s MATS.

Then I want to calculate the AVERAGE growth of the products and compare each product’s growth

against the AVERAGE growth.

This is my expressions:

**Month 4 2011 :** sum(if (Inmonths (1,Time, SetDateYear (** MonthAprilPrev**, max (total Year (Time))-1), 0), Value)) THE VARAIBLE MonthAprilPrev is 01/04/2011

**Month 4 2012 :** sum(if (Inmonths (1,Time, SetDateYear (** MonthApril**, max (total Year (Time))), 0), Value)) THE VARAIBLE

MonthApril is 01/04/2012

**Growth Month 4 2012 : **(sum(if

(Inmonths (1,Time,SetDateYear (** MonthApril**,max (total Year

(Time))), 0), Value))/sum(if

(Inmonths (1,Time,SetDateYear (

**,max (total Year**

*MonthAprilPrev*(Time))-1), 0), Value)))-1

**Ave Growth Month 42012: (I have just added TOTAL to theexpression)**

( sum(TOTAL if (Inmonths (1,Time, SetDateYear (** MonthApril**, max (total Year (Time))), 0), Value)) / sum(TOTAL if (Inmonths (1,Time, SetDateYear (

**, max (total Year (Time))-1), 0), Value)) ) -1**

*MonthAprilPrev*

This AVERAGE growth is not workingas you can see on screenshot: what I need to do is to sum the growth of

products that has values in MAT 2011 and MAT 2012 AND THEN I NEED TO DIVIDE THS

TOTAL INTO THE AMOUNT OF PRODUCTS THAT HAVE VALUES IN BOTH MAT 2011 AND MAT

2012

Then I can work out

**GrowthMonth 4 VS Market Growth 2012:**

((sum(if (Inmonths (1,Time, SetDateYear ((** MonthApril**)-0, max (total Year (Time))), 0), Value))/sum(if (Inmonths (1,Time, SetDateYear ((

**)-0, max (total Year (Time))-1), 0), Value)))-1)**

*MonthAprilPrev*-

(( sum(TOTAL if (Inmonths (1,Time, SetDateYear ((** MonthApril**)-0 , max (total Year (Time))), 0), Value)) / sum(TOTAL if (Inmonths (1,Time, SetDateYear ((

**)-0, max (total Year (Time))-1), 0), Value)) ) -1)**

*MonthApril*

The yellow marked figure is the actual expected results

Thank you

Regards

Louw