I’ve created a report that tallies inbound and outbound shipments and conditionally adds an expected monthly usage amount IF the outbound shipment value is 0.

Report

The ‘Last Day of Month Allotment’ column is calculated by looking at the sum of the monthly outbound (grouped by month) and if 0 it adds a default lot_size otherwise use 0.

Here is that formula:

=IIF(Int(ReportItems!Sum_of_Outbound.Value = 0), Fields!last_day_of_month_allotment.Value, 0)

The Daily Total column uses this formula:

=Fields!inbound_minus_outbound.Value – ReportItems!last_day_of_month_allotment.Value

Everything works fine until I get to the Balance column and I need to take a RunningValue of that Daily Total Column. Either way I do it – reference the TextBox Properties via:

RunningValue(Cint(ReportItems!Daily_Total_Column.Value),SUM,NOTHING)

or just copy the formula from the Daily Total Column verbatim it wont work because of the “Aggregate functions can be used only on report items contained in page headers and footers”.

Any suggestions would be appreciated – whether alternative coding or a different way to summarize the outbound tally and get the last day of month allotment. My main query is pretty fixed and can’t be altered so that the one option that wont work (changing it).

Thanks in advance!