Features Added in FOCUS 7.7.07

In this section:

The following features were added as of FOCUS 7.7.07.

Format Display Option for Percentage Calculation

How to:

The lowercase p display option converts a number to a percent by multiplying it by 100. It then displays the number followed by a percent symbol (%). This is different from the % format option, which does not calculate a percent, it just displays a percent symbol after the number.

Note: This option is not supported for output formats XLSX and EXL2K.

Syntax: How to Display a Percentage 

field/floatfmtp

where:

field

Is a numeric field.

floatfmt

Is a numeric format of type F or D.

Example: Displaying a Percentage Using Display Option p

The following request displays the PCT_INC field (which is a decimal value) and redisplays it as a percentage: 

TABLE FILE EMPLOYEE
PRINT PCT_INC PCT_INC/F10p
END

The output is:

  PCT_INC      PCT_INC                                 
  -------      -------                                             
      .10          10%
      .12          12%
      .10          10%
      .04           4%
      .00           0%
      .05           5%
      .00           0%
      .00           0%
      .10          10%
      .00           0%
      .00           0%
      .15          15%
      .00           0%
      .07           7%
      .00           0%
      .04           4%
      .00           0%
      .05           5%
      .00           0%
 Information Builders