WS: WW: Calculated Fields FAQs
(Doc ID 627484.1)
Last updated on AUGUST 03, 2023
Applies to:
JD Edwards World World Writer - Version A7.3 cume 4 and laterGeneric (Platform Independent)
Purpose
This document contains FAQs and troubleshooting tips when working with calculated fields in World Writer.
Questions and Answers
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Questions and Answers |
| Question 1: How do you set up a calculated field? |
| Question 2: What are the types of expressions used in a calculation? |
| Question 3: Unexpected results occur when using arithmetic operators (+ - * /). |
| Question 4: What does the INTEGER operand do? |
| Question 5: Error 1495 Field Name is Not Valid when attempting to create a new field. |
| Question 6: Error 1763 - Invalid Characters Found - on a calculation that uses a number less that 1. |
| Question 7: Error 1766 - Expected a right (or left) parenthesis. |
| Question 8: Is there a method to convert an alpha character string to numeric data? |
| Question 9: Can SUBSTR or the || (Concatenate symbol) be used on a numeric field? |
| Question 10: Can the absolute value for a field be calculated? |
| Question 11: Error 1762 - Invalid Field or Function Name. |
| Question 12: How do you put a column heading on a calculated field? |
| Question 13: How do you data select on a calculated field? |
| Question 14: Your field that subtracts a number of days from a julian date field does not work when rolling over to a new year. |
| Question 15: How to calculated the number of days difference between two date fields |
| Question 16: How to calculate the age of an employee in years and months. |
| Question 17: How to determine why Data Selecting on calculated field produces no records? |
| References |