Picture Format

[cagiv]

Hi @all,

is there any way to display swiss currency format in an entryfield?

Example: 1'000.00
Picture: N21.'2

I tried key-in pictures but it doesnt work.

Best regards

 

[ShankarJ]

Hi!

From the help ::

Numeric Result Format

@N9 4,550,000 Nine digits, group with commas (default)
@N_9B 4550000 Nine digits, no grouping, leading blanks if zero
@N09 004550000 Nine digits, leading zero
@N*9 ***45,000 Nine digits, asterisk fill, group with commas
@N9_ 4 550 000 Nine digits, group with spaces
@N9. 4.550.000 Nine digits, group with periods

Decimal Result Format

@N9.2 4,550.75 Two decimal places, period decimal separator
@N_9.2B 4550.75 Two decimal places, period decimal separator, no grouping, blank if zero
@N_9`2 4550,75 Two decimal places, comma decimal separator
@N9.`2 4.550,75 Comma decimal separator, group with periods
@N9_`2 4 550,75 Comma decimal separator, group with spaces

Signed Result Format

@N-9.2B -2,347.25 Leading minus sign, blank if zero
@N9.2- 2,347.25- Trailing minus sign
@N(10.2) (2,347.25) Enclosed in parens when negative

Dollar

Currency Result Format

@N$9.2B $2,347.25 Leading dollar sign, blank if zero
@N$10.2- $2,347.25- Leading dollar sign, trailing minus when negative
@N$(11.2) $(2,347.25) Leading dollar sign, in parens when negative

International

NOTE: With the implementation of the Euro, many of these symbols are now obsolete.

Currency Result Format

@N12_`2~ € ~ 1 5430,50 € Euro
@N12_`2~ F~ 1 5430,50 F France
@N~L. ~12` L. 1.430.050 Italy
@N~£~12.2 £1,240.50 United Kingdom
@N~kr~12`2 kr1.430,50 Norway
@N~DM~12`2 DM1.430,50 Germany
@N12_`2~ mk~ 1 430,50 mk Finland
@N12`2~ kr~ 1.430,50 kr Sweden


Regards

 

[cagiv]

Hi ShankarJ,

I know this, but there is no Picture (or I dont see it) for Swiss currency. Therefore my ask.

Best Regards

 

[ShankarJ]

Hi!

As an entry picture you could always use ::

@p<<<'<<<'<<#.##pB

but for printing purposes, you may need to assign the above format to a string & then strip of the leading '.

Regards

 

[cagiv]

Hi ShankarJ,

I already tried it, but the solution is not very nice for entryfields. I thought there is a better solution.

Thanks for your help.

Best Regards