Not knowing what your data looks like I'm going to assume something fairly simple will work for you.
Try creating a formula that is something like this:
{ledger.amount} - {ledger.adjust}
If either field can be null, you'll have to do something like this:
//Set up the variables and their default values
NumberVar amount := 0;
NumberVar adjust := 0;
//Set the values of the variables if the fields are not null
if not IsNull({ledger.amount}) then amount := {ledger.amount};
if not IsNull({ledger.adjust}) then adjust := {ledger.adjust};
//Set the final value
amount - adjust
Now sum that formula in your crosstab. This should get you the total difference between the two.
-Dell
IP Logged
