Previous Topic

Next Topic

Book Contents

Book Index

Calculated Field Operations

In the following example, a date field has two operations performed on it:

  1. The date is replaced by the quarter of that date, e.g. "January 14, 2008" becomes "Q1 2008".
  2. Text is added to the beginning of the field, e.g. "Q1 2008" becoming "Quarter: Q1 2008".

Linked Graphic

Any number of operations can be added here, and they're performed sequentially - one after the other - so the second operation gets the result of the first to work on.

Linked Graphic

Most of the operations available here are self-explanatory.

Operation

Action/Example

Add text to the end

 

Add text to the beginning

 

Convert to upper-case

"Smith, Dale" becomes "SMITH, DALE"

Convert to lower-case

"Smith, Dale" becomes "smith, dale"

Search & replace

Recursive replacement of text values; does not allow the replacement value to contain the source value.

Limit length of the text

If the text is longer than the number of characters you specify, it will be chopped off at the length you designate here.

Add years to a date

For all "Add XXX to a date", if the date is blank, no action is taken.

Add months to a date

 

Add weeks to a date

 

Add days to a date

 

Day of week

e.g. "Monday"

Week of year

 

Month of year

 

Quarter of year

 

Year portion of date

 

Fiscal month of year

 

Fiscal quarter of year

 

Fiscal year of date

 

Add/subtract number

 

Multiply

 

Divide

 

Round a number

14.5678, 2 becomes 14.57
143.56, -2 becomes 140.

Truncate a number

14.5678, 2 becomes 14.56
143.56, -2 becomes 140.

Choose text based on the field being TRUE or FALSE

All three of these take a wide view of "True" and "False": "1", "T", and "Y" are TRUE, "0", "N" and "F" are FALSE.

Choose a number based on the field being TRUE or FALSE

 

Choose a date based on the field being TRUE or FALSE

 

Date portion of a date/time value

 

Time portion of a date/time value

 

See Also

Calculated Fields

Mapped Field

Mapped Image Field