Attached is the earlier script for tha Actual allocation.
Now we had a new requirement for all Asset allocations, when the Source/Target Category is Actual, the Factor will need to be FCST of the Source time. Example, if we are running for ACTUAL/2012.MAR, the FACTOR will need to be MARFCST/2012.OCT.
When running Forecast Average Category, the Factor will need to be FCST, not FCSTAVG. Example, if we are running for MARFCSTAVG/2012.OCT then the Factor will need to be MARFCST/2012.OCT.
Can anyone please suggest on how we can change the logic of the script.
Thanks in Advance..