Skip to Content
0
Former Member
Jan 21, 2012 at 05:24 AM

Calculating data according to user entry

33 Views

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