Solved
summarize a formula field.
Posted on 2005-04-19
I would like to summarize a formula field by group. But when I go to add a summary field, it only allows me to summarize database fields, not forumlas.
A simple example, I wouldl ike to calculate the sum of the formula, the formula sums up the values on the row (rowSum), and the groupFormula sums up the rowSum for that group.
------group 1------
1 2 3 = 6
2 3 4 = 9
------------------
= 15
------group 2------
1 2 1 = 4
2 3 2 = 7
------------------
= 11
Does anyone know how to do this? I would be greatly appreciative of any assistance in this matter.