Skip to Content
Former Member
Feb 06, 2008 at 01:57 PM

Reporting Requirement


Hi all,

i am working on queries.i hve to calculate a KF called Buiness outlook.The calculation like below..

Business Outlook is a calculated key figure in the current year. Previous months Invoiced Sales, current month to Month +2 / +5 / +11 Plan, Month 3/6 till end of year Sales Targets.

now the problem is, if the current month is NOV or Dec then we can't give Targets. we can't use next year's targets.

can anyone tell me how to calculate..

Thanks in Advance....