Using functions in calculated expressions in Report Writer

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

TechKnowledge Content

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×