Because this is TEXT (numbers formatted as text) inside other text:
Place the € at the end, of course.
There are also custom functions that may help:
These tip may also help:
You are correct. Round() does not give you Precision, but truncates trailing zeros:
The SetPrecision() function doesn't help with currency:
So you must "parse" the number (as text). Int(myNumber) and Div(myNumber;Int(myNumber)) may help get the parts of the number. Only the 'remainder' needs to be text padded with 0(s)
Thank you - will try this. I have tried to use a text field as a step inbetween and added " €" but not really made it yet.
there's a big difference between floating window and dialog.
In a floating window you can use layout formatting, format your number as to always show € and 2 decimals (even thousands separator) without creating extra fields.
In a dialog you can't do that.
See attachment for a merge field formatting.
IMHO, dialogs are NOT the right tool for displaying informations to users.
It can be useful for you, for debugging, especially when you have full access but not a advanced FM with data viewer etc, but a dialog box is historically meant to deal with "shit happens" situations in which you don't want to take a decision at programming level: you build a short message condensing the situation in a few words and shift the decision burden to the user.
theyPay.fmp12.zip 64.8 K