cancel
Showing results for 
Search instead for 
Did you mean: 

Roll forward calculation monthly basis

bhagyesh_ravange
Active Participant
0 Kudos

Hi Expert

Model is YTD

I have requirement wherein my Roll forward calculation happens on monthly basis.

Below is the detailed calculation.

First calculation is current configuration result. I would like to achieve the result mentioned in Required Roll forward configuration. In Required Rollforward config opening balance changes and F_Movement is the changes during the month.

Accepted Solutions (0)

Answers (2)

Answers (2)

bhagyesh_ravange
Active Participant
0 Kudos

Balance carry forward rule

F_Activity business rule to calculate Movement

Flow Dimension

former_member186338
Active Contributor
0 Kudos

Please attach VISIBLE pictures (rules)! With visible dimension names...

bhagyesh_ravange
Active Participant
0 Kudos

This are the only rules and the dimension

former_member186338
Active Contributor
0 Kudos

Your rules screenshots are not readable - low resolution! Please replace screenshots!

bhagyesh_ravange
Active Participant
0 Kudos

Business rule to calculate F_ACTIVITY (i.e. movement during the period)

Business rule for carry forward

Flow Dimension

former_member186338
Active Contributor
0 Kudos

What is loaded to BPC (for FLOW dimension)?

bhagyesh_ravange
Active Participant
0 Kudos

Data is loaded to BALANCE Flow

bhagyesh_ravange
Active Participant
0 Kudos

Data from BW is loaded to Flow BALANCE.

bhagyesh_ravange
Active Participant
0 Kudos

Well I have used Account based calculation business rule and did following config to get last month closing balance as the current month opening balance. Just mentioned -1 in source period to get the F_TOT of last month to current month F_OPE

former_member186338
Active Contributor
0 Kudos

"First calculation is current configuration result." - Please describe your current configuration!