previous month balance

[former_member589105]

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

[former_member589105 · Accepted solution]

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.

[former_member589105]

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.

[former_member589105]

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).

[former_member589105]

zprbalance = previous month's balance. how can we derive this in end routine?