I have developed a columnar report with a derived column that divides a previous column by a number that yields a percentage of a purchase order used on weekly basis. This works nicely and the report does print out the calculated quantity line by line (week by week) in the report.

In the Group Footer 1 of that derived column, I wish to simply add up the derived weekly percentages as a grand total. Seems simple enough, except the sum function fails
because the Layout Element Adder, Summary Calculation, Sum fails to present the derived column LE as a choice to select from for the Sum calculation.

I tried many work arounds with no success.

Any input as to how to get the derived column to add up?

Thanks 

The Q&A Derived column spec looks like this:

Heading:Percent of PO Used
Formula: (#6/$13728.00)*100
Column Spec: 7, F(N3),T

The last line of the above spec

That worked Ray, thanks for a nice simple solution.