Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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