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?
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.