Custom Projection Formula for GMROL - ASO Cube

Summary:

Hi All,

I need some help how to write formula for Scenario dimension member in ASO Cube -

We have custom scenario called STL_Projection which shows Actuals for Actual Periods and Forecast for other Periods.

For example - If Actual Month closed is Jun, we show actuals from Jan - Jun and Forecast starting Jul - Dec. YearTotal would be Sum (Actual Periods) + sum(Forecast Periods).

We came across specific requirement to show GMROL Account Member with Dynamic Formula as Account.GrossProfit/Account.Wages.

STL_Projection in reports shows correct GMROL account Actual and Forecast Periods, but for YearTotal it's showing total sum as written in the formula. But we want to show the fraction