unknown
2009-02-21 01:06:12 UTC
Here is my situation: I have a report that I have separated
into 2 groups of data. I am taking group 2 data and using a
computed field to give me a sum() of the material costs for
that group of data. I then want to sum() all of those
computed fields for a "group 1" total. When I write the
equation to sum(compute_1 for group 1) the value that is
returned is exactly double what it should be. I have tried
this several times with different equations and no luck. I
read online from a Powerbuilder case in 2003, that it is not
possible to get an aggregate sum from an aggregate unless
you add some specific script to the report, which I do not
know how, nor want to do. Has there been any changes with
Infomaker since then that allow me to sum up a summed value
in a group? Thanks, Dan
into 2 groups of data. I am taking group 2 data and using a
computed field to give me a sum() of the material costs for
that group of data. I then want to sum() all of those
computed fields for a "group 1" total. When I write the
equation to sum(compute_1 for group 1) the value that is
returned is exactly double what it should be. I have tried
this several times with different equations and no luck. I
read online from a Powerbuilder case in 2003, that it is not
possible to get an aggregate sum from an aggregate unless
you add some specific script to the report, which I do not
know how, nor want to do. Has there been any changes with
Infomaker since then that allow me to sum up a summed value
in a group? Thanks, Dan