Query to Start Fiscal Year on July? YTD_Actual, YTD_Budget, Annual Budget, PYTD_Actual SQL
Hello Everyone, this is my draft query. Please advise what is missing to achieve the questions. Thank you so much.
SELECT DISTINCT
GB.PERIOD_NAME,
GCC.SEGMENT1,
FVS1.DESCRIPTION AS COMPANY_NAME,
GCC.SEGMENT2,
FVS2.DESCRIPTION AS FUND_TYPE,
GCC.SEGMENT3,
FVS3.DESCRIPTION AS REGION,
GCC.SEGMENT4 AS DEPARTMENT_CODE,
FVS4.DESCRIPTION AS DEPARTMENT_DESCRIPTION,
GCC.SEGMENT5 AS NATURAL_ACCOUNT_CODE,
FVS5.DESCRIPTION AS NATURAL_ACCOUNT_DESCRIPTION,
(SELECT NVL(SUM(GB1.PERIOD_NET_DR - GB1.PERIOD_NET_CR), 0)
FROM GL_BALANCES GB1
WHERE GB1.CODE_COMBINATION_ID = GB.CODE_COMBINATION_ID AND GB1.ACTUAL_FLAG = 'A') AS YTD_Actual,