cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Roll forward calculation monthly basis

bhagyesh_ravange
Active Participant
0 Likes
1,565

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 Likes

Balance carry forward rule

F_Activity business rule to calculate Movement

Flow Dimension

former_member186338
Active Contributor
0 Likes

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

bhagyesh_ravange
Active Participant
0 Likes

This are the only rules and the dimension

former_member186338
Active Contributor
0 Likes

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

bhagyesh_ravange
Active Participant
0 Likes

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

Business rule for carry forward

Flow Dimension

former_member186338
Active Contributor
0 Likes

What is loaded to BPC (for FLOW dimension)?

bhagyesh_ravange
Active Participant
0 Likes

Data is loaded to BALANCE Flow

bhagyesh_ravange
Active Participant
0 Likes

Data from BW is loaded to Flow BALANCE.

bhagyesh_ravange
Active Participant
0 Likes

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 Likes

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