What's new in Customer Journeys?

Connect and learn more! ×
How to sum detail line number in total line of etext payment file — Cloud Customer Connect
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

Received Response
2
Views
1
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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