This content has been marked as final.
Show 5 replies

3. Re: Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth
renske.hercules.0 Mar 21, 2016 7:16 AM (in response to Mahfooj Khan)Yes! This does come close to what im looking for but..:
 it should show only the Show+Series+Channel and then a number of the average growth (only the blue boxes in attached image)
 For series with only 1 week, there is no average weektweek growth. So then it should say Null. (see red in attached image) I dont understand why it calculated a number because statistically its not right..right?
Please let me know if you have a solution !

4. Re: Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth
Mahfooj Khan Mar 21, 2016 10:10 PM (in response to renske.hercules.0)Hi,
I've done some calculation on WeektWeek AVG growth. I'm not having any number for the same.
Mahfooj

Show AVG Growth.twbx 41.1 MB


5. Re: Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth
renske.hercules.0 Mar 23, 2016 3:10 AM (in response to Mahfooj Khan)Thanks a lot! Its perfect