Skip to Content
avatar image
Former Member

Roll forward calculation monthly basis

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.

mn9vu.png (20.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 01 at 11:15 AM

    Balance carry forward rule

    F_Activity business rule to calculate Movement

    Flow Dimension

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

      2dwac.png (10.8 kB)
  • Feb 01 at 08:49 AM

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

    Add comment
    10|10000 characters needed characters exceeded