Moving Average

[tzussman]

Dose any one know how to do Moving Average in Crystal 11?

 

[mrudolph]

A moving average implies a time-series set of data. So most likely you will have to calculate the time differential you are dividing by (whether days,hours, etc...). You may likely be able to use a Crystal summary or running total for the numerator that will sum the items.

It also depends on whether you are doing a simple moving average or weighted, etc...

see the following Wikipedia article for more info that will help you determine what type of formula you will need to set up in Crystal to emulate the equation for the type of moving average you are attempting.

http://en.wikipedia.org/wiki/Weighted_moving_average

Unfortunately your post doesn't give enough detail to render a more detailed answer.

mrudolph

 

[tzussman]

Thanks. I know how to calculate MA but my question is if there is a formula in Crystal or do I need to create my own.
I need to do a simple MA for sales for the last 18 month’s
Did summary of the total sale per month and now I’m trying to do MA for those

Thanks
Tomer

 

[mrudolph]

Crystal does not have a built in moving average function, so you will have to utilize running total/summaries and then creat a formula field to do the final calculation for your simple MA.

Will you always be dividing by 18 months? If so, then your denominator can be a constant 18, and you will just need to utilize running total fields or summary fields that will create your numerator total for the particular 18 month period you are running the report for. But you will need to create a formula field that divides your final total of the sales for the 18 months by 18.

regards,
mrudolph