December 7, 2013 at 12:57 am
Hello Experts !
I have a data sheet attached as a sample...
In column B dates are placed, Column C having data, column D average data of last 5 days and column E having forcasted values.
My question i need a sql query which looks if the data in column C is less then column E ( 100000 value) then go to and get last previous 5 days values as average?
Tnx
December 9, 2013 at 4:26 am
farrukhhameed786 (12/7/2013)
Hello Experts !I have a data sheet attached as a sample...
In column B dates are placed, Column C having data, column D average data of last 5 days and column E having forcasted values.
My question i need a sql query which looks if the data in column C is less then column E ( 100000 value) then go to and get last previous 5 days values as average?
Tnx
Maybe some friendly advice?
Not everyone is that comfortable opening up attachements and even then you word your question more like you're trying to get someone to do your work for you?
Maybe you post what you have tried and exactly where you are stuck, I bet you get better and more targeted help then.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply