suppress sum of sum

[atarrqis]

Oracle and CR11
I have 1 group on {PRODUCT} and 10 formulas
If account = x then STOCK,
If account = y then WIP, etc.
The formulas are summed by group.
I also have a formula TOTAL
which takes the SUM{STOCK}+SUM{WIP}+, etc.
I want to suppress the GF1 where {@TOTAL} = 0
This doesn't work - I still get the zero lines.
I tried using a variable:
WhilePrintingRecords;
NumberVar TOT := SUM{STOCK}+SUM{WIP}+, etc.
and then suppressing if this formula = 0 but I still get the zero lines.
Must be missing something....

 

[lbass]

If at the group level,you should have a group condition built into your summaries:

sum({@stock},{table.group})+sum({@wip},{table.group})

Also if either the account or the amount field can be null, you would need to build that into each conditional formula.

//{@stock}:
if isnull({table.account}) or
isnull({table.stock}) then
0 else
{table.stock}

-LB

 

[atarrqis]

a group condition built into your summaries"

Isn't this what my {@TOTAL} is doing with
WhilePrintingRecords;
NumberVar TOT := SUM{STOCK}+SUM{WIP}+, etc.
at my GF1?

 

[lbass]

No--that would show the grand total at every group section.

-LB