Skip to Content
0
Former Member
Dec 20, 2007 at 11:46 AM

Acutal & Plan calculations

32 Views

I need to execute a query using the following rules.

a) Actual Value (Up to the previous period(From the first fiscal period of the current fiscal year to Current fiscal period - 1))

b) Plan Value (Plan value(Version 0) for the current period + Actual Value as described in point a)

c) Total (Actual Value as described in point a + Plan Value FOR THE CURRENT PERIOD AS DESCRIBED IN POINT B) PLUS for the rest of the fiscal periods OF THE CURRENT FISCAL YEAR )

plase help me regarding this.

Thanks in advance.