Format Pattern: #.##

PHPMaker General Discussion (PHPMaker)
1

Hi,
I am using the version 2022.5.0.
I want to have two decimal for my field for exp: 847.70.
But right now I am getting 847.7I am using two local setting: en-US and de-CH
number (de-CH): #,##0.###
numner (en-US): #,##0.###View Tag:
Format: Number
Format pattern: #.##The field is in mysql as Decimal(10,2).

Where to check?
mpol_ch

2

For two decimal, then make sure you have already entered the following pattern:#,##0.00from Fields setup → View Tag pane → Format → Format pattern after that re-generate ALL the script files again.

3

Note that:

  • “#” means replacing the “#” symbol with the corresponding digit if one is present; otherwise, no digit appears in the result string.
  • “0” means replacing the zero with the corresponding digit if one is present; otherwise, zero appears in the result string.

If you want to always show “0”, you should use #,##0.00.See Locale Settings → number for more information.