HI All,
i want to calculate previous months balance in sap bw . i have created keyfigure and mapped it to balance which is populating as per current month.
Now i need to populate this previousbalance keyfigure with previous fiscalperiod. can we do this with endroutine?
Awaiting your inputs.let me know if you need more inputs.
Raki
4 Answers
-
Best AnswerPosted on Oct 23, 2019 at 06:25 AM
issue resolved . to get prev balance we have sued balance - turnover = prev balance formula in field routine.
we have turn over and balance available in flow already.
Add a comment
-
Posted on Oct 22, 2019 at 07:51 AM
zprbalance = previous month's balance. how can we derive this in end routine?
Add a comment
-
Posted on Oct 24, 2019 at 06:11 AM
But what if i dont have turnover in flow ?? how can i achieve this?
requiremetn is is prevmonths balance should come into zprevbal keyfirue.
date field is 0fiscper ( format is : 2019005 for example).
Add a comment
-
Posted on Oct 29, 2019 at 04:27 AM
using current member option in replacement , we can derive previous month balance.
create repalcement path on 0fiscper with current member option. and do substraction between currentmember - currentmember-1 variables.
Add a comment
Add a comment