Integrated Financials
 Tablix2 (Tablix)
  Properties
Property Value
DataSetName PercentageSpendingCurrentFY_Query
Top
Height 1in
Width 10.65626in
Style None
Left
ZIndex
Column Count 3
  Tablix Body
Body Item Body Item Content Name Content Type Content Value
Row Cell JournalToPriorYearPeriodAmount Textbox =Sum(Fields!JournalToPriorYearPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount Textbox =IIf(IsNothing(sum(Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value)), "", Sum(Fields!JournalToPriorYearPeriodAmount.Value) / Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value)
Cell JournalToPeriodAmount Textbox =Sum(Fields!JournalToPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount1 Textbox =IIf(IsNothing(sum(Fields!TotalExpensesToPeriodJournalAmount.Value)), "", Sum(Fields!JournalToPeriodAmount.Value) / Fields!TotalExpensesToPeriodJournalAmount.Value)
Cell Rectangle1 Rectangle
Row Cell Textbox55 Textbox =Sum(Fields!JournalToPriorYearPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount2 Textbox =IIf(IsNothing(sum(Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value)), "", Sum(Fields!JournalToPriorYearPeriodAmount.Value) / Fields!TotalExpensesToPriorYearPeriodJournalAmount.Value)
Cell Textbox57 Textbox =Sum(Fields!JournalToPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount3 Textbox =IIf(IsNothing(sum(Fields!TotalExpensesToPeriodJournalAmount.Value)), "", Sum(Fields!JournalToPeriodAmount.Value) / Fields!TotalExpensesToPeriodJournalAmount.Value)
Cell Rectangle2 Rectangle
Row Cell Textbox3 Textbox =Sum(Fields!JournalToPriorYearPeriodAmount.Value)
Cell Textbox12 Textbox
Cell Textbox5 Textbox =Sum(Fields!JournalToPeriodAmount.Value)
Cell Textbox11 Textbox
Cell Textbox10 Textbox
  Row Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member Group Gl_Class =Fields!Gl_Class.Value
Header Textbox Gl_Class =Fields!Gl_Class.Value
Member Header Textbox Textbox1 Total
  Column Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member Group ColumnGroup
Header Textbox Textbox30 Prior Year
Member Header Textbox Textbox37 Current Year , =Fields!Fiscal_Year.Value
Member Header Textbox Textbox63
Powered by BI Documenter