Salesforce

Examples of Numeric Pictures (Magic xpa 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Examples of Numeric Pictures (Magic xpa 3.x)

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