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.