Using Value Formatting for Displayed Variables

With some report items, you can apply formatting to a displayed value, by setting them as Units or Text. This can be especially helpful when displaying height or time values.

• For example, a person’s height might be stored in inches (e.g. 75), but you want to display in inches and feet. Under Apply formatting
  • In the Type drop down, select Units.
  • In the Source Value Units, select Inches.
  • In the Value Format field, you would enter “FF’ II”” (without the double quotes on each end).
  • This would display the person’s height in the report as 6’ 3”.
• If you select the Text option, you can combine multiple variables using the Value Formatting feature.
  • For example, if you wanted to display a person’s hometown and home state in the format “Springfield, MO”, you would select “Home Town” as the 1st variable and “Home State” as the 2nd one selected.
  • You would set the formatting type to Text and enter “{0}, {1}” (this uses a zero-based reference, meaning the first item=0.)
  • If you wanted to display the format as “MO – Springfield”, you would type “{1} – {0}”.
• Note: formatting is an advanced feature that requires some knowledge of programming.

= = = = =

Version(s): 18.1 and later