How to sumthe value of rows

[nikol]

Is there any way I can sum the values of rows except for Cross-tab method?

Row1 row2 row3 Total1
High 1 1 4 6
Low 1 1 3 5
Very Low 3 2 1 5

Total2 5 4 8
How Can I find "Total1

 

[dawtes]

create a formula and add the rows


Row1 + Row2 + Row3

and place the formula in the report under total1

 

[lbass]

Assuming that "high, low, and very low" are instances of a group, and that the rows are sums of a conditional formula, you should be able to just insert a summary on your detail level field at the group level, i.e., the sum of all "rows" (really columns here) is the same as the sum for the group. You could accomplish the same thing by creating a formula:

sum({table.groupfield},{table.groupfield})

...although this is unnecessary.

If you created the summaries using running totals instead, then the total column would be a running total with no conditdions added, but reset on change of group.

-LB