sum of computed fields (Infomaker 8)

[bert]

I have 3 different computed fields (each is a sum for a
group). now I want to sum up this 3 fields with another
computed field, but it doesn´t work. why?
thx
bert

[Matthew Miller]

have you named each of the computed fields?
<bert> wrote in message news:40d97f00.324...@sybase.com...

[Matthew Miller]

I asked that becuase I recall having problems selecting computed fields and
then trying to summ them by clicking the sum() object via the toolbar. But,
if you name the computed fields you can add a computed field and reference
the names in your sum expression, thus accomplishing the same thing, except
with a little more work on your end.

<bert> wrote in message news:40d97f00.324...@sybase.com...

[bert]

Hi,
I named the computed fields in group1: computeSumNameA,
computeSumNameB, computeSumNameB
and now I want do sum them up in group2 ("higher level")
with the compute expression:
(computeSumNameA + computeSumNameB + computeSumNameC)

But the result in the report is only the value of
computeSumNameA

[orshoham]

As a rule of thumb, IM does a bad job of dealing with
multiple aggregations (computed fields on computed fields,
in this case). The best solution is simply not to use them -
instead of using Compute1 + Compute2 + Compute3, use:
Sum(X for group 3) + Sum(Y for group 3) + Sum(Z for group 3)
- or whatever other formulas you used for the original
computed fields. This is somewhat bulky, but it works.
Alternatively, any report-level action such as sorting,
filtering, etc. should fix the problem (sometimes you'll
have to repeat that action two or three times to get the
desired result), but this tends to be impractical.
Or

[haiderali]

Hi bert,
Although I am new to Infomaker, I would suggest try this.
Select another cumputed field add the follwoing code in the
compute expression window.
compute_field1 + compute_field2 + compute_field3
press on verify to verify your code and then press ok.
In this way you can add as many computed fields as you can.
Hopefully it will be helpfull for you :)
Haider

[woomich...@gmail.com]

I am new as well for infomaker, and add a new column to select query, and how to add this new co,umn to a group .. I checked in Row->edit group, there are two grouped. But allwayys get an ero for group all.. any advice..