Facing issue for using the SUBSTR function with negative number in eText Template

RamuV

We have requirement to print the last 4 digits from summed value in eText template. We have used the below code to print the last 4 digits but its not working. please let me know if any one of you worked on similar requirement.

SUBSTR((SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’Net Pay’]/RUN)*100)+SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’GPR POSITIVE PAY FEDERAL ELEMENTS GROUP’]/GPR_CUSTOM_BAL))

),length(SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’Net Pay’]/RUN)*100)+SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’GPR POSITIVE PAY FEDERAL ELEMENTS GROUP’]/GPR_CUSTOM_BAL))

)-3)

Mallikarjuna Kuppauru-Oracle

Hi @RamuV

You can refer below for examples -

https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T481436.htm

Example - SUBSTR(ConctenatedInvoiceInfo, 1, 4) -If you want to use only the first four characters of the concatenated invoice info,

My suggestion is to split the functions and verify one by one.

Regards,

Arjun