Question:
How do I use functions in calculated fields in Report Writer (
Tools - Customize - Report Writer)?
Answer:
Functions cannot be applied to, or nested with, other functions.For example, you cannot use the
STRIPfunction to remove extra spaces from a field you’re already using the
CUR_STRfunction with to convert the field to a string field.The following examples illustrates this type of expression:
Not permitted: STRIP (CUR_STR ( Beginning Balance ) )
If the field you wish to create requires using two functions, you must create a calculated field using one of the functions, then create another calculated field, using the second function with the first calculated field, as in the following example:
Calculated field 1: CUR_STR ( Beginning Balance )
Calculated field 2: STRIP (Calculated field 1)
This article was TechKnowledge Document ID:24985
How do I use functions in calculated fields in Report Writer (
Tools - Customize - Report Writer)?
Answer:
Functions cannot be applied to, or nested with, other functions.For example, you cannot use the
STRIPfunction to remove extra spaces from a field you’re already using the
CUR_STRfunction with to convert the field to a string field.The following examples illustrates this type of expression:
Not permitted: STRIP (CUR_STR ( Beginning Balance ) )
If the field you wish to create requires using two functions, you must create a calculated field using one of the functions, then create another calculated field, using the second function with the first calculated field, as in the following example:
Calculated field 1: CUR_STR ( Beginning Balance )
Calculated field 2: STRIP (Calculated field 1)
This article was TechKnowledge Document ID:24985