Grouped formula with summed values - ?Use these values in sep formula 1

[IceRuby]

Utilising Crystal Version 10 linked via ODBC to SQL database.

Via a formula I have set up defined groups, then a summation is completed on each defined group. Is it possible to create a specified formula on these group summations?

E.g Grouping formula
if {transaction_type} = "WORK" and {tax_category} = "GROSS"
then "Salaries" else
if {transaction_type} = "ALLOWANCE"
then "Allowance" else
if {transaction_type} = "DEDUCTION" and (paye_tax_category} = "GROSS" and not({short_description} like "*Pre*") and not({short_description} like "SGC")
then "Deductions"

This linked to Group #1 providing me with

Salaries $10,000
Allowance $2,000
Deductions $3,000

Summed values are absolute so I need to be able to create a formula from this group to sum Salaries + Allowances and subtract Deductions. (10,000 + 2,000 - 3000) = 9,000

Appreciate your help

 

[lbass]

Create another formula:

if
(
{transaction_type} = "WORK" and
{tax_category} = "GROSS"
) or
{transaction_type} = "ALLOWANCE"
then {table.amt} else
if {transaction_type} = "DEDUCTION" and
(paye_tax_category} = "GROSS" and
not({short_description} like "*Pre*") and
not({short_description} like "SGC")
then -{table.amt} else
0

Place this in the detail section and then insert a summary on it.

-LB