Row |
Cell |
ExpenseToPriorYearPeriodAmount |
Textbox |
=Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) |
|
Cell |
TotalExpensesToPeriodJournalAmount |
Textbox |
=IIf(IsNothing(Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "",
Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) / Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")) |
|
Cell |
ExpenseToPeriodAmount |
Textbox |
=Sum(Fields!ExpenseToPeriodAmount.Value) |
|
Cell |
TotalExpensesToPeriodJournalAmount1 |
Textbox |
=IIf(IsNothing(Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")),
"",
Sum(Fields!ExpenseToPeriodAmount.Value) / Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")) |
|
Cell |
Rectangle1 |
Rectangle |
|
Row |
Cell |
Textbox43 |
Textbox |
=Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) |
|
Cell |
TotalExpensesToPeriodJournalAmount2 |
Textbox |
=IIf(IsNothing(Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "", Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) / Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")) |
|
Cell |
Textbox45 |
Textbox |
=Sum(Fields!ExpenseToPeriodAmount.Value) |
|
Cell |
TotalExpensesToPeriodJournalAmount5 |
Textbox |
=IIf(IsNothing(Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "", Sum(Fields!ExpenseToPeriodAmount.Value) / Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")) |
|
Cell |
Rectangle3 |
Rectangle |
|
Row |
Cell |
ExpenseToPriorYearPeriodAmount1 |
Textbox |
=Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) |
|
Cell |
TotalExpensesToPeriodJournalAmount4 |
Textbox |
=IIf(IsNothing(Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "", Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) / Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")) |
|
Cell |
ExpenseToPeriodAmount1 |
Textbox |
=Sum(Fields!ExpenseToPeriodAmount.Value) |
|
Cell |
TotalExpensesToPeriodJournalAmount3 |
Textbox |
=IIf(IsNothing(Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")),
"",
Sum(Fields!ExpenseToPeriodAmount.Value) / Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")) |
|
Cell |
Rectangle2 |
Rectangle |
|
Row |
Cell |
ExpenseToPriorYearPeriodAmount2 |
Textbox |
=Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) |
|
Cell |
Textbox5 |
Textbox |
|
|
Cell |
ExpenseToPeriodAmount2 |
Textbox |
=Sum(Fields!ExpenseToPeriodAmount.Value) |
|
Cell |
Textbox11 |
Textbox |
|
|
Cell |
Rectangle7 |
Rectangle |
|