Jump to content

calculating %ch in MYSQL


algorithm

Recommended Posts

Suppose you have a table with two fields, Date and Value. I want to use php to calculate Year over Year percent change? How do I efficiently get the previous year's value as well as start exactly one year after my initial date (since you can't calculate %ch if there are no previous values)?

 

 

Link to comment
https://forums.phpfreaks.com/topic/192881-calculating-ch-in-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.