You can do this in several ways. For this I am guessing each row has a "Type" field that uses the values of "Pencil1, Pencil 2, ..., Confirmed" and an amount field that is used for the dollar amounts regardless of the type....
1. Make 2 if then formula fields that give you the values based on the "type" and then sum each of those formula fields.
e.g.
formula "Pencil" as
if table.typefield<>"Confirmed" then table.amountfield else 0
formula "Confirmed" as
if table.typefield="Confirmed" then table.amountfield else 0
Do a Sum at group level on each formula.
2. Create variable formulas for each
3. use Running Totals (with conditional record inclusion)
You will need 2 for the group level and 2 for the report footer level if you want that displayed also.
Post if you want/need help with either option 2 or 3.
Edited by DBlank - 14 Sep 2009 at 8:56am
IP Logged
