Welcome to the Oracle Analytics and AI Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

HI @Mohammed Rafi , For more clarifications, We need to calculate the grand total sum of the BRANCH_NUMBER column. Because the length of this total is unpredictable and can scale up to 30 digits depending on the employee headcount, the system must dynamically extract and return only the trailing (last) 10 digits of the…

in Facing issue for using the SUBSTR function with negative number in eText Template Comment by Sai.Bomma Jun 9, 2026 2:54PM
Hi Rafi, I have a tried with the below code but still it is fetching the first 10 numbers instead the last 10 numbers. SUBSTR(TO_CHAR(SUM(TO_NUMBER(PAYMENT_RECORD/PAYMENT_DETAILS/DESTINATION_BANK/BRANCH_NUMBER))),-10)

in Facing issue for using the SUBSTR function with negative number in eText Template Comment by Sai.Bomma Jun 9, 2026 2:14PM
HI Ramu, I have a similar situation requirement, Did we got any resolution for this issue in E- text Template? Best Regards, Sai

in Facing issue for using the SUBSTR function with negative number in eText Template Comment by Sai.Bomma Jun 9, 2026 10:13AM
HI Ramu, Did we got the solution in RTF template? Best Regards, Sai

in Facing issue for using the SUBSTR function with negative number in eText Template Comment by Sai.Bomma Jun 9, 2026 10:11AM