You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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")))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!