Skip to Content
0
Former Member
Jan 19, 2011 at 05:13 PM

Show percentage based on summary values in cross-tab

33 Views

I am using Crystal XI. I have a cross-tab that has actual hours and standard hours as the summary fields. The column is operation and the row is clock#. I need an additional column that shows an efficiency percent. It would be the sum of standard hours divided by the sum of actual hours times 100. Is there a way to do this? I tried inserting a formula while in cross-tab expert but it does not seem to have the summary fields available to choose.