Salesforce

Examples of Numeric Pictures (Magic xpi 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Examples of Numeric Pictures (Magic xpi 3.x)

The table below shows examples of Numeric pictures.

Contents of Parameter

Picture

Result

Comment

-1234.56

######.##

^^1234.56

Negative not allowed

-1234.56

N######.##

^^-1234.56

Negative allowed

-1234.56

N######.##C

^^-1,234.56

Commas in display

-1234.56

N######.##L

-1234.56^^

Left-justified

-1234.56

N######.##P*

-**1234.56

Pad fill with asterisks

0

N######.##Z*

*********

Zero fill with asterisks

-13.5

N##.##-DB;

DB13.50

Sign of negative values is DB

45.3

N##.##+CR;

CR45.30

Sign of positive values is CR

-13.5

N##.##-(,);

(13.50)

Negative sign prefix and suffix is ( )

4055.3

$######.##

$^^4055.30

Mask character used in display only

The ^ symbol represents a one-space character.

Reference
Attachment 
Attachment