Calc Script rule is overriding the previous calculation
Hi,
We are trying to write a calculation the calculation manager but it seems when we add the second section (Customer) in the rule first section (Distribution) values are changed, what could be the possible error?
Below is the script:
SET HYBRIDBSOINCALCSCRIPT FULL;
FIX("FCCS_No Intercompany", "No Future 1", "No Future 2", "No Cost Centre", "Local_GAAP", "FCCS_Periodic")
/Clear Final Validation Account/
FIX("Final Validation","FCCS_No Movement")
"FCCS_Data Input"= #missing;
ENDFIX
/Final Validation/
/Distribution/
FIX ("Final Validation","FCCS_No Movement")
"FCCS_Data Input" (
IF(@ISMBR("EN_3999") AND ((@ABS(("EN_B019"->"Validation Hierarchy"->"Total Future 1"->"Total Future 2"->"Total Cost Centre"->"FCCS_Total Data Source"->"FCCS_Movements"->"FCCS_Intercompany Top"->"FCCS_Entity Total"->"Group_Final"))) > ("EN_B019"->"Validation Threshold"->"Total Future 1"->"Total Future 2"->"Total Cost Centre"->"FCCS_Total Data Source"->"FCCS_Movements"->"FCCS_Intercompany Top"->"FCCS_Entity Total"->"Group_Final")))