Totals not working 1

[tr0ubleduser]

Hi all,

I am working with CR 10 and SQL server 2000. My report is based on a view. There are 6 columns which are currently in the details section. I have a written a formula to calculate the "Total" column. For some reason the column is not showing any values and is just balnk. The report layout is as follows.

Case # Name Back Pay Attorney Fee Lump Sum Total
1 John 200.00 500.00
2 James 105.00 25.00

The columns that are refernced in the totals formula are of currency type. My totals formula is as follows.

{cr_formal_settlements.Back Pay} +
{cr_formal_settlements.Lump Sum} +
{cr_formal_settlements.Attorney Fees}

I have placed this formula in the details section too. Any ideas why this would return no values (blank)?

 

[lbass]

If one of the components is null, the total will be. Try:

(if isnull({cr_formal_settlements.Back Pay}) then 0 else {cr_formal_settlements.Back Pay}) +
(if isnull({cr_formal_settlements.Lump Sum}) then 0 else {cr_formal_settlements.Lump Sum}) +
(if isnull({cr_formal_settlements.Attorney Fees})
then 0 else {cr_formal_settlements.Attorney Fees})

-LB

 

[tr0ubleduser]

Thanks for the quick and accurate response.

 

[synapsevampire]

The otehr option is to go into File->Report Options and turn on convert null values to default, no code required then.

-k