Categories
- All Categories
- 10 Oracle Analytics Sharing Center
- 13 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Facing issue for using the SUBSTR function with negative number in eText Template
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
-
Hi @RamuV
You can refer below for examples -
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
1
