Forum Stats

  • 3,759,045 Users
  • 2,251,494 Discussions
  • 7,870,477 Comments

Discussions

Ratio Calculation Based on POV Accounting Period -Fusion Financial Reporting Studio

Year Dimension - 2018

Accounting Period Dimension - Jan-18, Feb-18, Mar-18, Apr-18 ........Dec-18

Customer Requirements - Row Calculation based on POV - Accounting Period

Column: Current Month and Previous Month

Ratio Analysis Average Calculation for Current Month(For E.g. POV Accounting Period -Mar-18 is 3rd Month)

= ([4,A]+[12,A])* 3/12

Ratio Analysis Average Calculation for Previous Month(For E.g. POV Accounting Period -Feb-18 is 2rd Month)

= ([4,A]+[12,A])* 2/12

Please help on above queries how to achieve dynamically POV Accounting Period calculation Mar-18 to 3 and Feb-18 to 2 in this case.