Formatting with Velocity

Classic Servoy
1

Hi

I have been using the Velocity reports extensively on a financial product as a consequence the number format should be £1,000.00. I am using the following in the template

$number.format($currency,$myfield)

context.currency = ‘¤#,###.00’

What is peculiar about this is some fields format correctly and others truncate.

eg.

7700 = £7,700.00
8147.34 = £8 //if the formatting is removed it is OK and reverts to 8147.34

What I do not see is why this should not still work on the basis:

¤ = currency
, = splitter
. = decimal

I have tried changing the default float fields to Decimals but it is still throwing up this error, ideas as to why would be very gratefully received

Gordon

2

Very weird! Is there a difference in the provenance of these 2 numbers?
Would you happen to have a sample of that where this could be reproduced?

If so, please open a bug report on ServoyForge, attach this and a link to this messahe and I’ll have a look: https://www.servoyforge.net/projects/ve … issues/new

Thanks!