Substitution Variable is not working every time

Summary:

we are using substitution variable to pick a previous month to run the calc script. it does work fine, when all Entities are impacted but when we run consolidation again then numbers are vanish.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

24.06.86

Code Snippet (add any code snippets that support your topic, if applicable):

FIX ("FCCS_Periodic", "Entity Currency", @REMOVE(@Relative("DS_Total_Supplementary", 0), @LIST("DS_CALC")), "FCCS_Managed Data", @Relative("DS_Total_ConsAdjs", 0), "DS_RGL_DM_Journals", "DS_RGL_LateAdjs", "FCCS_No Intercompany", @RELATIVE("Total Custom1", 0), "No Custom2", @RELATIVE("C3_P1000", 0), @RELATIVE("C4_SYSMEM", 0), "SN_CFL_10100")