Hello Rajesh.
Please refer below sample example in 9AEXAMPLES View( MacroExamples) macrobook using /sapapo/advm.
Here is link to SAP Help which has details on this function or other functions.
Date Functions - Planning Area Administration - SAP Library
Hope this will help.
Thank you
Satish Waghmare
Hi
You could use the macro function TIMESHIFT_BACKWARDS()
From SAP Help:
TIMESHIFT_BACKWARDS( X1 ; ... ; Xn ; Y1 ; ... ; Yn ) shifts the values of time series X1 through Xn backward in time by the number of periods given in time series Y1 through Yn.
Example:
The time series looks like this: X 10 20 30 40 50 Y 1 2 1 3 1. The result looks like this: 30 40 30 - 50 -
The value 10 is shifted back one period in time, the value 20 is shifted back two periods in time, and so on.
Add a comment