correct this formula?

[pollux0]

I am new to coding in cryst. rep.

I want to create a formula similar to this SQL statement:

total = Sum(debitAmount) where {journalEntry.accountIdNumber} = {account.accountIdNumber}

 

[synapsevampire]

Set your table join to accomplish:

{journalEntry.accountIdNumber} = {account.accountIdNumber}

Then create a group for:
account.accountIdNumber

Drop the {debitAmount} field in the detail, right click it and select insert summary and use sum. Now delete the {debitAmount} field.

You can also use a Running Total to do this.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Naith]

If you're unable to join on these two fields, you could still accomplish this by using formulas:

//Start//
whileprintingrecords;
numbervar total;

if {journalEntry.accountIdNumber} = {account.accountIdNumber}
then total := total + {debitAmount}
else total;
//End//

Naith