Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to sum detail line number in total line of etext payment file

in Payables, Payments & Cash Management 1 comment

Hi All,

I have a bank requested field in my etext payment file , It's in the line level and calculated by specify formula.

And now I'd like to sum the fields of line record in my total level.

here is the logic of that field:

Substr(Replace(PayeeBankAccount/BankAccountNumber,’-’,’’),5,2)*PaymentAmount/Value*100

+Substr(Replace(PayeeBankAccount/BankAccountNumber,’-’,’’),7,2)*PaymentAmount/Value*100

+Substr(Replace(PayeeBankAccount/BankAccountNumber,’-’,’’),9,2)* PaymentAmount/Value*100


But after I use sum function like the following, it return wrong number.

sum(Substr(Replace(PayeeBankAccount/BankAccountNumber,’-’,’’),5,2)*PaymentAmount/Value*100

+Substr(Replace(PayeeBankAccount/BankAccountNumber,’-’,’’),7,2)*PaymentAmount/Value*100

+Substr(Replace(PayeeBankAccount/BankAccountNumber,’-’,’’),9,2)* PaymentAmount/Value*100).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!