Rule to aid a YTD data load doesn't work every of the time

Summary:DSO application. YTD GL data loads. Created a rule that aids with entering a zero as appropriate to assists with the Movement rollforwards (the ClosingBalance Input member).

Content (required):This rule works most of the time, however sometimes we have to load a 2nd or a 3rd time to trigger the functionality.

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

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

FIX ("Entity Currency", "Entity Input", "FCCS_Periodic") 

 FIX ("[CostCenter].[No CostCenter]", "[General].[No General]", 

 @Relative("Total LegalEntity", 0), 

 @Relative("Total ProfitCenter", 0)) 

    FIX (@REMOVE(@RELATIVE("FCCS_Total Balance Sheet", 0),