Load Script: FieldValue() function does not evaluate dual values(text values)
Article Number: 000057345 | Last Modified: 2018/11/22
When using FieldValue() function to fetch data, especially those data that contains both dual values(text values) and numeric values, from other fields in Load Script, the result might be shown as "?" on front end.
As demonstrated in "FieldValue Demo.qvw", F2 is loaded using FieldValue() against F1. In the front end, F2 values are shown as "?".
This is a known limitation with the fieldvalue() function when used in the script.
In short, all numerical values have a raw numerical value and a dual (formatted) value. The dual value is not established at this point since it is dependent on sorting (first format encountered) and the possibility that the field exists in more than one table and as a consequence the format is "unknown" which is displayed as "?".
The recommendation is to use the num() function in order to force a dual format which will make it possible to display the value in a formatted form. Please refer to "FieldValue Workaround.qvw"