Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion HCM Analytics

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
11
Views
1
Comments
RamuV
RamuV Rank 1 - Community Starter
in Oracle Fusion HCM Analytics

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)

Answers