R
Rose B
Is there any way that I can use a calculated field (a group total) as the
basis for creating another calculation? I want to be able to add up all of
the totals from a group in a grand total. The reason is that in my underlying
query I have joined header and detail information and my calculations at the
group level can take a total of detail and then take off a header value - and
that works fine since the field is only shown at the header level in the
report =sum([DetailField])-[HeaderField], but at the grand total level that
does not work.
basis for creating another calculation? I want to be able to add up all of
the totals from a group in a grand total. The reason is that in my underlying
query I have joined header and detail information and my calculations at the
group level can take a total of detail and then take off a header value - and
that works fine since the field is only shown at the header level in the
report =sum([DetailField])-[HeaderField], but at the grand total level that
does not work.