Versions Compared

Old Version 3

changes.mady.by.user Shindie Linatoc

Saved on

compared with

New Version 4

changes.mady.by.user Shindie Linatoc

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

This procedure works when the Business Type of the Dataset Column Display is set to Number.
business type


How to

...

customize in the

...

Format window

  1. Navigate to Widgetson the MSPbots app. 
  2. Find the widget for customization in the My Widgets tab and open it using any of the following ways:
    • Click the widget. 
      My Widgets

    • Click the ellipsis button and select Edit.  
      edit widget

      Alternatively, you can also click the ellipsis  button on the widget on your dashboard and select Edit. 
      edit widgetImage Modified 
  3. When the Widget Builder window appears, go to Dataset, click the ellipsis button, and select Edit. 
    edit widget 
  4. When the Dataset window appears, find the column name for customization and select the corresponding  icon. 
    customize formattingImage Modified 
    Note

    Ensure that you are customizing the column with Number as the selected Business Type, else the customization will not succeed. 


  5. Click Custom on the Format pop-up. 
    Image Removedcustom formatImage Added

  6. Type your preferred format in the Custom field. Be guided by the formatting options below. 
    For example, if you want 10000 to be displayed as 10,000.0000, enter 0,0.0000 into the Custom field.
    custom formatImage Added
  7. Click Save on the Format pop-up.
  8. Click Save on the Dataset window to keep your customizations.

...

OrderField Value (raw format) FormattingOutputDescriptionDescriptions
110000       0,0.000010,000.0000
  • Adds separators
in
  • to the whole number
where appropriate and
  • as needed
  • Appends four digits after the decimal point
.
210000.230,010,000
  • Adds separators
in
  • to the whole number
where appropriate and rounds to
  • as needed
  • Rounds off to the nearest whole number
.
310000.23+0,0+10,000
  • Rounds off to the nearest whole number
, adds separators where appropriate, and displays
  • Adds separators as needed
  • Displays positive or negative notations where it is appropriate
.
4-100000,0.0-10,000.0
  • Adds separators
in
  • to the whole number
where appropriate and
  • as needed
  • Adds one digit after the decimal point
and displays
  • Displays positive or negative notations where it is appropriate
.

510000.12340.00010000.123
  • Rounds off to three decimal places
and rounds to  the nearest  number.
  • Rounds off to the nearest number
6100.12340000000100
  • Rounds off to the nearest whole number
and keeps
  • Keeps five digits in the integer part
.
71000.1234000000,0001,000
  • Rounds off to the nearest whole number
and  adds
  • Adds separators in the whole number
where appropriate and keeps
  • as needed
  • Keeps six digits in the integer part
.
810000.00010.00
  • Adds two digits after the decimal point
and keeps
  • Keeps three digits in the integer part
.
910000.12340[.]0000010000.12340
  • Adds five digits after the decimal point
and if
  • Displays the whole number if there is no decimal
, displays whole number.
10-10000(0,0.0000)(10,000.0000)
  • Adds four digits after the decimal point
and
  • Adds separators in the whole number
where appropriate. If
  • as needed
  • Shows the number inside parentheses if it is negative
, it appears in parenthesis.
11-0.23.00-.23
  • Strips off the whole number
and displays
  • Displays only the decimals up to two digits after the decimal
.
  • point
12-0.23(.00)(.23)
  • Strips off the whole number
and displays
  • Displays only the decimals up to two digits after the decimal
.If
  • point
  • Shows the number
is negative, it appears in parenthesis.
  • inside parentheses if it is negative 
130.230.000000.23000
  • Adds five digits after the decimal point and displays the whole number
.
140.230.0[0000]0.23
  • Displays one digit after the decimal
with
  • but has an allowance for up to five
total, if appropriate, and displays the whole number.
  • decimal places if these are needed
  • Displays the whole number 
1512309740.0a1.2m
  • Rounds off to the nearest thousandth
and adds
  • value
  • Adds one digit after the decimal point
and displays
  • Displays a letter for the magnitude change, with a space between the magnitude symbol and the
number.  
  • number  
1614600 a1 k
  • Rounds off to the nearest thousandth
and displays
  • value
  • Displays a letter for the magnitude change
.
17-1040000a-104k
  • Rounds off to the nearest thousandth
and displays
  • Displays a letter for the magnitude change
.
1810o1st
  • Adds
ordinal letters
  • suffixes after the
number, rounds to the nearest whole
  • ordinal number (for example: 1st, 2nd, 3rd, 4th
...).
  • , and so on)
  • Rounds to the nearest whole number 
191000o100th
  • Adds
ordinal letters
  • suffixes after the
number, rounds to the nearest whole
  • ordinal number (for example: 1st, 2nd, 3rd, 4th
...).

Currency

  • , and so on)
  • Rounds to the nearest whole number 

Formatting Guide for Currency

You can use (Use the $ symbol in the formatting, however, but the output will be the your local currency sign $,  ££, or € or € ) (Local Currency is based on account language setting.)
OrderField Value (raw format) FormattingOutputDescription
11000.234$0,0.00$1,000.23Adds separators in the whole number where appropriate and rounds two digits after the decimal point  and rounds to  the nearest  number and adds the local currency symbol before the number.
21000.20,0[.]00 $1,000.20 $Adds separators in the whole number where appropriate and rounds two digits after the decimal point  and rounds to the nearest  number and adds the local currency symbol after the number and if no decimal, displays whole number.
31001$ 0,0[.]00$ 1,001Adds separators in the whole number where appropriate and rounds two digits after the decimal point  and rounds to the nearest  number and adds the local currency symbol before the number and if no decimal, displays whole number.
4-1000.234($0,0)($1,000)Adds separators in the whole number where appropriate, rounds to the nearest whole number, and adds the local currency symbol before the number. If the number is negative, it shows in parenthesis.
5-1000.234$0.00-$1000.23Adds two digits after the decimal point, rounds to the nearest number, and adds the local currency symbol before the number.
61230974($ 0.00 a)$ 1.23 mDisplays the nearest thousandth with two digits after the decimal, a letter for the magnitude change, and the local currency symbol before the number.If the number is negative, it shows in parenthesis.

...