Calculation of monthly report For day to days change values

Posted by Ravianand under Sql Server on 6/21/2012 | Points: 10 | Views : 1236 | Status : [Member] | Replies : 2
My scenario
I want to calcualte quantity of diesel with Cost(diesel*Cost) for monthly basis but now a days diesel price changes day to day,or week to week......
how to calculate monthly report basis.
Very urgent.....

Regards,
Ravi



Responses

Posted by: Naraayanan on: 6/22/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
It is an Idea .. Try it...
Get avg of Price of the Month and calculate Every Day quantity of diesel...
Or
FIFO /LIFO Method.


Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Ravianand, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ravianand on: 6/22/2012 [Member] Starter | Points: 25

Up
0
Down
I have to calculate full month report in single query
Ex:Diesel price changes two times in a month
Calculation(Quantity * dieselPrice)
Where condition only month and year as input

Regards,
Ravi

Ravianand, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response