Skip to Content
-1
May 25 at 06:23 PM

Calculate both periodic and YTD results for various formulas via Member Formulas or Script Logic?

114 Views

Hello ,

Product version: BPCNW 10.1 Classic

In the model Planning, we have dimensions TIME,VERSION,ACCOUNT,COMPANY_CODE,PROFIT CENTER,AUDIT TRAIL,CURRENCY.

This model is periodic.

Requirement:- I need to calculate the various formulas /ratios based on filters provided by users.

1.These formulas need to be calculated as both Periodic and YTD.

2. Ratios/Formulas need to be run for current and prior year for actual category and the budget category (passed by user).

3. I do have some calculations which involves different time periods, like one of the example is below:-

inventory ratio for current year:-Current month Actual Inventory/Average of next 3 months Budget Sales. What is best to use here member formula or script logic?

OUPUT:- The report layout that I need to provide is below:-

Can anyone help me with how to get the logic work for both Periodic and YTD calculations for various categories at a time.

Thanks,

Ambika

Attachments

rpt.png (7.9 kB)