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
Using functions in calculated expressions in Report Writer
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
