0 RSDS_EnterpriseDW_SSAS None 95e0f472-c858-414f-a622-ca1d5b24daa5 RSDS_EnterpriseDW None 7907d136-bd1a-4a23-8946-c4d59bfb5bf6 RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value =Parameters!DateCalendarPeriodFilter.Value =Parameters!OrgUnitFundCode.Value =Parameters!OrgUnitControlOrgUnit.Value =Parameters!OrgUnitReportDistribution.Value =Parameters!OrgUnitOrgUnitGrouping.Value =Parameters!OrgUnitLocationDescription.Value =Parameters!UserId.Value Select { [Measures].[JournalToPeriodAmount] ,[Measures].[JournalToPriorYearPeriodAmount] ,[Measures].[TotalExpensesToPeriodJournalAmount] ,[Measures].[TotalExpensesToPriorYearPeriodJournalAmount] } on Columns, NON EMPTY { [Gl Code].[Gl Class].[Gl Class].ALLMEMBERS* [Gl Code].[Gl Class Code].[Gl Class Code].ALLMEMBERS* [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS* [Gl Code].[Gl Category Code Desc].Children* [Gl Code].[Gl Sub Category Description].Children* [Gl Code].[Glc Code Description].Children } on rows FROM ( SELECT STRTOSET(@DateFiscalYear) ON COLUMNS FROM ( SELECT {[Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7]} ON COLUMNS FROM [Executive_Integrated_Financials] ) ) WHERE ( STRTOSET(@OrgUnitLocationDescription) ,STRTOSET(@OrgUnitOrgUnitGrouping) ,STRTOSET(@OrgUnitReportDistribution) ,STRTOSET(@OrgUnitControlOrgUnit) ,STRTOSET(@OrgUnitFundCode) , {[Gl Trans Detail].[Journal Grouping].&[Actuals]} , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7)) , NONEMPTY ( [Org Unit].[Org Unit SK].[Org Unit SK].Members, ( STRTOMEMBER(@UserId) ,[Measures].[Fact Org Unit User Bridge Count] ) ) ) MDXQueryGl CodeGl Class[Gl Code].[Gl Class]Gl Class[Gl Code].[Gl Class].[Gl Class]Gl ClassGl CodeGl Class Code[Gl Code].[Gl Class Code]Gl Class Code[Gl Code].[Gl Class Code].[Gl Class Code]Gl Class CodeDateFiscal Year[Date].[Fiscal Year]Fiscal Year[Date].[Fiscal Year].[Fiscal Year]Fiscal YearGl CodeGl Category Code Desc[Gl Code].[Gl Category Code Desc]Gl Category Code Desc[Gl Code].[Gl Category Code Desc].[Gl Category Code Desc]Gl Category Code DescGl CodeGl Sub Category Description[Gl Code].[Gl Sub Category Description]Gl Sub Category Description[Gl Code].[Gl Sub Category Description].[Gl Sub Category Description]Gl Sub Category DescriptionGl CodeGlc Code Description[Gl Code].[Glc Code Description]Glc Code Description[Gl Code].[Glc Code Description].[Glc Code Description]Glc Code DescriptionJournalToPeriodAmount[Measures].[JournalToPeriodAmount]JournalToPeriodAmounttrueJournalToPriorYearPeriodAmount[Measures].[JournalToPriorYearPeriodAmount]JournalToPriorYearPeriodAmounttrueTotalExpensesToPeriodJournalAmount[Measures].[TotalExpensesToPeriodJournalAmount]TotalExpensesToPeriodJournalAmounttrueTotalExpensesToPriorYearPeriodJournalAmount[Measures].[TotalExpensesToPriorYearPeriodJournalAmount]TotalExpensesToPriorYearPeriodJournalAmounttrueExecutive_Integrated_FinancialsSelect { [Measures].[JournalToPeriodAmount] ,[Measures].[JournalToPriorYearPeriodAmount] ,[Measures].[TotalExpensesToPeriodJournalAmount] ,[Measures].[TotalExpensesToPriorYearPeriodJournalAmount] } on Columns, NON EMPTY { [Gl Code].[Gl Class].[Gl Class].ALLMEMBERS* [Gl Code].[Gl Class Code].[Gl Class Code].ALLMEMBERS* [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS* [Gl Code].[Gl Category Code Desc].Children* [Gl Code].[Gl Sub Category Description].Children* [Gl Code].[Glc Code Description].Children } on rows FROM ( SELECT STRTOSET(@DateFiscalYear) ON COLUMNS FROM ( SELECT {[Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7]} ON COLUMNS FROM [Executive_Integrated_Financials] ) ) WHERE ( STRTOSET(@OrgUnitLocationDescription) ,STRTOSET(@OrgUnitOrgUnitGrouping) ,STRTOSET(@OrgUnitReportDistribution) ,STRTOSET(@OrgUnitControlOrgUnit) ,STRTOSET(@OrgUnitFundCode) , {[Gl Trans Detail].[Journal Grouping].&[Actuals]} , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7)) , NONEMPTY ( [Org Unit].[Org Unit SK].[Org Unit SK].Members, ( STRTOMEMBER(@UserId) ,[Measures].[Fact Org Unit User Bridge Count] ) ) )DateFiscalYear[Date].[Fiscal Year].&[FY 2013]Date.Fiscal Year[Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueDateCalendarPeriodFilter[Date].[Calendar Period Filter].&[201211]DateCalendarPeriodFilter[Date].[Calendar Period Filter]WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Calendar Period Filter].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Calendar Period Filter].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Calendar Period Filter].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Calendar Period Filter].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]OrgUnitFundCode[Org Unit].[Fund Code].[All]Fund Code[Org Unit].[Fund Code]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Fund Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Fund Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Fund Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Fund Code].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitControlOrgUnit[Org Unit].[Control Org Unit].[All]Control Org Unit[Org Unit].[Control Org Unit]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Control Org Unit].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitReportDistribution[Org Unit].[Report Distribution].[All]Report Distribution[Org Unit].[Report Distribution]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Report Distribution].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Report Distribution].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Report Distribution].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Report Distribution].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitOrgUnitGrouping[Org Unit].[Org Unit Grouping].[All]Org Unit Grouping[Org Unit].[Org Unit Grouping]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Org Unit Grouping].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Org Unit Grouping].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Org Unit Grouping].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Org Unit Grouping].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueUserId[User].[Domain User Id].&[ad\scowan]UserId[User].[Domain User Id]WITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]OrgUnitLocationDescription[Org Unit].[Location Description].[All]OrgUnitLocationDescription[Org Unit].[Location Description]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Location Description].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Location Description].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Location Description].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Location Description].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]true <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Gl Code].[Gl Class].[Gl Class]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Date].[Fiscal Year].[Fiscal Year]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Gl Code].[Gl Class Code].[Gl Class Code]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Gl Code].[Gl Category Code Desc].[Gl Category Code Desc]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Gl Code].[Gl Sub Category Description].[Gl Sub Category Description]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Gl Code].[Glc Code Description].[Glc Code Description]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[JournalToPeriodAmount]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[JournalToPriorYearPeriodAmount]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[TotalExpensesToPeriodJournalAmount]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[TotalExpensesToPriorYearPeriodJournalAmount]" /> System.Int32 RSDS_EnterpriseDW_SSAS WITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] MDX Query ParameterCaption [Measures].[ParameterCaption] ParameterCaption true ParameterValue [Measures].[ParameterValue] ParameterValue true ParameterLevel [Measures].[ParameterLevel] ParameterLevel true Executive_Integrated_Financials WITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] true true <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" /> System.Int32 =Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value System.String RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Calendar Period Filter].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Date].[Calendar Period Filter].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Date].[Calendar Period Filter].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Date].[Calendar Period Filter].Children ON ROWS FROM ( SELECT StrToSet (@DateFiscalYear ,CONSTRAINED ) ON COLUMNS FROM [Executive_Integrated_Financials] ) MDXQueryDateCalendar Period Filter[Date].[Calendar Period Filter]Calendar Period Filter[Date].[Calendar Period Filter].[Calendar Period Filter]Calendar Period FilterParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Date].[Calendar Period Filter].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Date].[Calendar Period Filter].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Date].[Calendar Period Filter].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Date].[Calendar Period Filter].Children ON ROWS FROM ( SELECT StrToSet (@DateFiscalYear ,CONSTRAINED ) ON COLUMNS FROM [Executive_Integrated_Financials] )DateFiscalYear[Date].[Fiscal Year].[All]DateFiscalYear[Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Date].[Calendar Period Filter].[Calendar Period Filter]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" /> System.Int32 RSDS_EnterpriseDW SELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color FROM Configuration_Color WHERE (ReportType = 'GeneralLedger') BackgroundColor System.String BackgroundAlternateColor System.String Band1Color System.String Band2Color System.String Band3Color System.String Band4Color System.String Band5Color System.String Band6Color System.String RSDS_EnterpriseDW SELECT ImageType, ImageLocation FROM Configuration_Image WHERE (ImageType = 'UpArrow') ImageType System.String ImageLocation System.String RSDS_EnterpriseDW SELECT ImageType, ImageLocation FROM Configuration_Image WHERE (ImageType = 'DownArrow') ImageType System.String ImageLocation System.String true true =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 2 1.22917in 0.72917in 1.27083in 0.82292in 1in 0.25in true true =Sum(Fields!JournalToPriorYearPeriodAmount.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),True) 2pt 2pt 2pt 2pt true true =IIf(IsNothing(sum(Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value)), "", Sum(Fields!JournalToPriorYearPeriodAmount.Value) / Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt true true =Sum(Fields!JournalToPeriodAmount.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt true true =IIf(IsNothing(sum(Fields!TotalExpensesToPeriodJournalAmount.Value)), "", Sum(Fields!JournalToPeriodAmount.Value) / Fields!TotalExpensesToPeriodJournalAmount.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt External =IIF(Sum(Fields!JournalToPeriodAmount.Value) / Fields!TotalExpensesToPeriodJournalAmount.Value > Sum(Fields!JournalToPriorYearPeriodAmount.Value) / Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value, First(Fields!ImageLocation.Value, "GetImageUpArrow"),First(Fields!ImageLocation.Value, "GetImageDownArrow")) FitProportional 0.34249in 0.23958in 0.28125in =Sum(Fields!JournalToPeriodAmount.Value) / Fields!TotalExpensesToPeriodJournalAmount.Value = Sum(Fields!JournalToPriorYearPeriodAmount.Value) / Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value true =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 0.25in true true =Sum(Fields!JournalToPriorYearPeriodAmount.Value) 2pt 2pt 2pt 2pt true true =IIf(IsNothing(sum(Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value)), "", Sum(Fields!JournalToPriorYearPeriodAmount.Value) / Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!JournalToPeriodAmount.Value) 2pt 2pt 2pt 2pt true true =IIf(IsNothing(sum(Fields!TotalExpensesToPeriodJournalAmount.Value)), "", Sum(Fields!JournalToPeriodAmount.Value) / Fields!TotalExpensesToPeriodJournalAmount.Value) 2pt 2pt 2pt 2pt External =IIF(Sum(Fields!JournalToPeriodAmount.Value) / Fields!TotalExpensesToPeriodJournalAmount.Value > Sum(Fields!JournalToPriorYearPeriodAmount.Value) / Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value, First(Fields!ImageLocation.Value, "GetImageUpArrow"),First(Fields!ImageLocation.Value, "GetImageDownArrow")) FitProportional 0.34249in 0.23958in 0.28125in =Sum(Fields!JournalToPeriodAmount.Value) / Fields!TotalExpensesToPeriodJournalAmount.Value = Sum(Fields!JournalToPriorYearPeriodAmount.Value) / Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value true 0.25in true true =Sum(Fields!JournalToPriorYearPeriodAmount.Value) 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =Sum(Fields!JournalToPeriodAmount.Value) 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true White 2pt 2pt 2pt 2pt 0.25in true true Prior Year Textbox30 =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true Current Year =Fields!Fiscal_Year.Value =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Gl_Class.Value =Fields!Gl_Class_Code.Value 1.52083in true true =Fields!Gl_Class.Value 2pt 2pt 2pt 2pt =Fields!Gl_Sub_Category_Description.Value =Fields!Gl_Sub_Category_Description.Value 4.08334in true true =Fields!Gl_Sub_Category_Description.Value =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt true Gl_Class 4.08334in true true Total 2pt 2pt 2pt 2pt Before 1.52083in true true Total 2pt 2pt 2pt 2pt 4.08334in true true 2pt 2pt 2pt 2pt Before PercentageSpendingCurrentFY_Query =iif((IsNothing(Fields!JournalToPeriodAmount.Value) and IsNothing(Fields!JournalToPriorYearPeriodAmount.Value)) or (Fields!JournalToPeriodAmount.Value = 0 and Fields!JournalToPriorYearPeriodAmount.Value = 0), 1, 0) Equal 0 1in 10.65626in 1.16542in