Ok what i have is something like this,
GH1 - name, Max(@cost)
Details(suppressed) - name, @cost
I have to use the a formula to pull the "cost" from the database because there are many types of costs in the database and im only interested in one kind.
And each item may have many of this type of cost assigned to them, i don't need to see all these as im only interested in the "max cost".
I've used a summery to pull the max out of the details and put that value in the group header, and ive suppressed the details sections containing the un-needed data.
However I now need to do a "sum" on these Maxcosts and it won't let me perform one on a summery field.
Any idea's??
GH1 - name, Max(@cost)
Details(suppressed) - name, @cost
I have to use the a formula to pull the "cost" from the database because there are many types of costs in the database and im only interested in one kind.
And each item may have many of this type of cost assigned to them, i don't need to see all these as im only interested in the "max cost".
I've used a summery to pull the max out of the details and put that value in the group header, and ive suppressed the details sections containing the un-needed data.
However I now need to do a "sum" on these Maxcosts and it won't let me perform one on a summery field.
Any idea's??