Performance issue on a custom calc in FCCS_10 Opening Balance Carry Forward Rule

Content

Dear Expert,

I have a performance issue with a custom rule puts into the FCCS_10 Opening Balance Carry Forward Rule.

The requirement is to calculate a percentage to be applied to a specific account. This percentage needs to be calculated only for the Actual scenario.

Another requirement is that the numerator and denominator to calculate the percentage are Revenues and Costs where I need to calculate a value for 12 months rolling in the past.

Below a semplification

	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20
Acc1	100	105	110	115	120	125	130	135	140	145	150	155
Acc2	50	55	60	65	70	75	80	85	90	95	100	105
											rolling Acc1	1530
											rolling Acc2	930
											percentage calculated as 930/1530	60,8%

I notice the calculation puts in insertion rule is "heavy", but my problem is that when I run a scenario where I don't need to have that calculation, the execution performance are quite the same. Specially when I need to run a consolidation for a scenario and for 12 months, like in a monthly budget.