I have a summary field that totals hours. This number is displayed on subsummary parts.
I want to multiply this by cost/hour (a field in a related table) and display on the same subsummary part. So I can have the total cost summarized at two different levels.
I've tried using the GetSummary command but it returns blank. (I think because the fields are not in the same table.)
I've tried other ways that use this summary field, but in doing so the number I get is always the total of the hours in the found set, not the subsummary.
Seems like this should be simple. How can I get this to display the proper calculation?