Formatting Numeric Data - Numbers

Screen ID: 

Screen Title: 

Panel Number:

images\kb_closed_shg.gif

CU*BASE Report Builder (Query)

Describe Numeric Field Editing

QRYDFNM2

images\qrydfnm2g_shg.gif
Click here to magnify

This screen will appear when you use the Numeric Editing (1) on the initial Format Numbers screen.

Check out the video related to this topic: Formatting Account Numbers and Dates (More videos below!)

Helpful Resources

Learn how to format currency values.

Learn how to format account numbers.

Screen Overview

Use this screen to choose a numeric format for quantity, currency, rate, and other numeric fields. When done, use Enter to save changes and return to the Format Columns screen.

Field Descriptions

Field Name

Description

Decimal point

Choose one of the options shown to select the decimal point you wish to use. If “None” is selected, a dollar figure of $1,325.35 will appear as 132535. Choose period (.) to show that figure as 1325.35.

Thousands separator

Choose one of the options shown to select a thousands separator. If “None” is selected, a dollar figure of $1,789 will appear as 1789. Choose comma (,) to show that figure as 1,789.

  • HINT: For the account base field (ACCTBS), choose “None”.

Show negative sign
 Left negative sign
 Right negative sign

Check this checkbox to include a special symbol for negative numbers, then enter the symbol to be used on the left and/or right side.

  • HINT: To display a negative figure as 123.23-, enter a dash (-) in Right negative sign field. To display a negative figure as (123.23), enter a left parenthesis in Left negative sign and a right parenthesis in Right negative sign.

Show currency symbol
 Left currency symbol
 Right currency symbol

Check this checkbox to include a currency symbol with the number, then enter the symbol to be used on the left and/or right side of the column. For U.S. currency, enter a dollar sign ($) in Left currency symbol. Currency symbols will be aligned along the left edge of the column, like this:

 $ 4,323.25

 $ 32.03

 $ 329.79

  • HINT: This feature can also be used for percentages, by entering a percent sign (%) in Right currency symbol.

Print zero value

Check this checkbox to print a zero (0) when the value in the field is zero. If you wish a zero-value field to appear as a blank, choose No instead.

Replace leading zeros
 Replace with
 Single leading zero

Check this checkbox to replace leading zeros with other characters, then select the character to be used. The most common use for this is to use blanks in place of the leading zeros in front of member account numbers (instead of 000003497, you would see 3497 as the account number).

However, with the account type suffix field (ACTTYP), choose No to retain the leading zeros so that account suffix “001” does not appear as “1”.

  • HINT: Use Floating currency symbol (3) to place the currency symbol you selected earlier directly in front of the dollar amount, instead of at the left edge of the column, like this:

  $4,323.25

  $32.03

  $329.79

If you wish to replace all of the leading zeros but leave a single leading zero behind, choose Yes in the Single leading zero field. A common example would be in a field containing a numeric month: May could appear as 05 instead of 5.

Additional Video Resources

Formatting Dollar Amounts

View more Query videos.

Visit the Show Me the Steps video library to view more videos!

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#QRYDFNM2g.htm