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
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