Dear All ,
i need to design a query where i need to calculate proportionate budget according to the month entered by the user . for eg
if total budget is 50000 then proportionate budget should be total budget * ( entry by the user any month)/12.
how can i do it . help shall be highly appreciated.
thanks
Ritu