Skip to Content
0
Dec 08, 2008 at 08:25 AM

Need dynamic formula and display in query

18 Views

Hi,

We have a requirement where the user enters the month and year as input.

If user enters 04.2008 means my formula should be like

YTD= total employee Quit/

(Opening Headcount of april1st2008Closing Headcount of April end 2008)/2

)/N*365/No of days elapsed * 100

and If user enters 05.2008 the formula should be

YTD= total employee Quit/

((Opening Headcount of april1st2008Closing Headcount of April end 2008)/2

(Opening Headcount of may 1st 2008 + closing Headcount of May end 2008)/2 ))/N*365/No of days elapsed * 100

April 2008 wil always be the starting of calculation

Can anyone please tell how we can achieve this type of dynamic formula ?

Thanks in Advance