Nested agregate function

[Ico]

Hi , all
I have the folowing problem.
DW with one group and computed field in group -
max(col1 for group 1) with name cfd_max
At the summary section i had another computed field
sum(cfd_max for all) - but the result is not correct.
Can i solve this problem ?
Thanks, in advance

[Michael Chernin]

The result you'll get is a sum(max(col1 for group1) *
num_of_rows_for_group_1).
I guess what you really need is sum of max's for all groups. If that's
right, you may create a detail band comp field tmp_comp like:

if (getrow() = [first_row_in_the_group], cfd_max, 0))

and then just sum(tmp_comp).

"Ico" <i...@nospam.com> wrote in message news:42ef6ad3@forums-1-dub...