DTS Y-T-D Calculation on Stat Account
Summary: Cannot retrieve correct calc on stat account using DTS
Content (please ensure you mask any confidential information): Two new stat accounts were created called EBITDA and EBITDAR. Regular retrieves correctly pull the balances however utilizing DTS Y-T-D does not output the correct balance.
Is there a certain configuration necessary to attune for DTS when setting up a new account?
Groovy
SET AGGMISSG ON;
SET UPDATECALC OFF;
SET CALCPARALLEL 3;
FIX(&Curr_Act_Month, &Curr_Act_Year, "Actual", "Final (Local)", "Final (USD)", @RELATIVE("Income Statement",0),@RELATIVE("Balance Sheet",0),@RELATIVE("Statistical Accounts",0))
AGG ("Department", "Cost Center", "Legal Entity", "Line of Business", "Contracts");