Num function digits after the comma

[ez]

Hello,

I have to format an expression into an expression with 2,3 or 4 digits after the comma:

1335,1 - 1.335,10

1335,14  - 1.335,14

1335,145 - 1.335,145

1335,1456 - 1.335,1456

1335,14567- 1.335,1457

I tried

Num( 1335,1456, '#.##0,00##', ',' , '.' ),

but there is no difference to

Num( 1335,1456, '#.##0,0000', ',' , '.' ) .

Any suggestions?

Thank You

ez

[marcus_sommer · Accepted solution]

You could set the formatting explicitely depending on the number of digits. The following looked a bit ugly but it worked:

num(1335.1, '#.##0,' & repeat('#', rangemax(2, rangemin(len(subfield(1335.1, '.', 2)), 4))))

- Marcus

[ez]

Thank you Marcus,

it works.