Using functions in calculated expressions in Report Writer


TechKnowledge Content


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