Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

is there any function in SQL SERVER

Status
Not open for further replies.

azeemkhn

IS-IT--Management
Jan 15, 2020
6
QA
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

Check out our Macola tools:

 
Have you you looked at the advanced Windows functions (over... partition). Seems like I read an article on how to do a moving average with it.
 
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

Check out our Macola tools:

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top