|
-
Jun 18th, 2004, 01:08 PM
#1
Thread Starter
Addicted Member
Minimum Value in Group 2 from Aggregated result in Group 3
Hi There,
I have a 3 groups in a report.
Group 3 has a Formula (Formula1) returning average of a field based on group 2. eg:- Average({Table.Field},Group3)
I want to display the minimum Value returned by Formula1 in Group2's Header.
How can I do that? if i write Minimum(Formula1,Group2) it says "This field cannot be summarized" cause i have used a aggregate in Formula1.
Help will be appriciated.
"Trouble Gives Experience & Experience Gives Wisdom."
(accept troubles as they come to become more wise in life)
 - Regards Rohan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|