Using functions in calculated expressions in Report Writer

TechKnowledge Content


How do I use functions in calculated fields in Report Writer (
Tools - Customize - Report Writer)?


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