Using RTP in FCCS

@SUMRANGE(&quot

Summary

Using RTP in FCCS

Content

Hi,

 

We are converting one HFM application into FCCS application.

 

 

The following rule has been written in HFM:

HS.Exp "A#FM_13Avg_Rec" & Nones & " = " & Average("A#GL_Total_Rec" & Tops,"13")

 

 

We have converted this in FCCS rule as under:

"FM_13Avg_Rec" = (@SUMRANGE("GL_Total_Rec"->&ICPTopLevel->&DeptTopLevel->&DSTopLevel->FCCS_Movements->"FCCS_Entity Total", @XRANGE(&PrevYear->&CurrMonth, &CurrYear->&CurrMonth)))/13;

 

 

FCCS application is providing the expected results but the issue we have is that FCCS rule is relying on the Substitution Variable. There is a big risk that the client may not change the variable value before running the consolidation each period, which will lead to the wrong ratio calculations in FCCS. We tried enabling RTP in FCCS but the system is not allowing us to do so.