is there any function in SQL SERVER 2012 to calculate moving average or running moving average?? if no, please guide how moving average can be calculated ??
Not that I am aware of. However you should be able create your own formula in Crystal. So how do you define "moving average" or "running moving average"? It is best to provide data examples and desired results in your post.
Macola Software Veteran and SAP Business One Consultant on Training Wheels
You should post this in a SQL forum, not Crystal Reports. You'll probably get a better response there.
The vast majority of crystal reports do not use SQL commands, although undoubtedly it is translating the design to SQL statements and uses the SQL engine.
Macola Software Veteran and SAP Business One Consultant on Training Wheels
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.