Versions Compared

Old Version 3

changes.mady.by.user Shindie Linatoc

Saved on

compared with

New Version Current

changes.mady.by.user Shindie Linatoc

Saved on

Key

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

...

Table of Contents
 

Note

This procedure works only when the Business Type of the Dataset Column Display is set to Number.
business typeImage Removedbusiness type numberImage Added


How to

...

customize values in your widget

  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 Image Modified 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.

Formatting Guide for Numerals

raw format where appropriate and . where appropriate and rounds to ., adds separators where appropriate, and displays . where appropriate and and displays . and rounds to  the nearest  number. and keeps . and  adds where appropriate and keeps . and keeps . and if , displays whole number. and where appropriate. If , it appears in parenthesis. and displays . and displays .If is negative, it appears in parenthesis.. with total, if appropriate, and displays the whole number. and adds and displays number.   and displays . and displays . ordinal letters number, rounds to the nearest whole ...). ordinal letters , rounds to the nearest whole number (...).
OrderField Value (
Raw Format) FormattingOutputDescription
110000       0,0.000010,000.0000
  1. Adds separators in the whole number
  1. as needed
  2. Appends four digits after the decimal point
210000.230,010,000
  1. Adds separators in the whole number
  1. as needed
  2. Rounds off to the nearest whole number
310000.23+0,0+10,000
  1. Rounds off to the nearest whole number
  2. Adds separators as needed
  3. Displays positive or negative notations where it is appropriate
4-100000,0.0-10,000.0
  1. Adds separators in the whole number
  1. as needed
  2. Adds one digit after the decimal point
  2. Displays positive or negative notations where it is appropriate

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

Currency

...

  1. , and so on)
  2. Rounds to the nearest whole number 

Formatting Guide for Currency

The symbol for local currency in the widgets is based on your account language settings. You can use the dollar $ sign in the formatting,

...

however, the output will

...

show your local currency

...

($,

...

£,

...

or € ). 

raw format and rounds  and to  nearest  and adds . and rounds  and nearest  and adds and if displays and rounds  and nearest  and adds before and if displays , rounds , and adds . If the number is negative, it shows in parenthesis digits , rounds , and adds number. digits , , and .If the number is negative, it shows in parenthesis.
OrderField Value (
Raw Format) FormattingOutputDescription
11000.234$0,0.00$1,000.23
  1. Adds separators in the whole number where appropriate
  2. Takes the two digits after the decimal point
  1. and rounds
  1. it off to the
  1. nearest number
  2. Adds the local currency symbol before the number
21000.20,0[.]00 $1,000.20 $
  1. Adds separators in the whole number where appropriate
  2. Takes the two digits after the decimal point
  1. and rounds it off to the
  1. nearest number
  2. Adds the local currency symbol after the number
  2. If there is no decimal,
  1. the whole number is displayed.
31001$ 0,0[.]00$ 1,001
  1. Adds separators in the whole number where appropriate
  2. Takes the two digits after the decimal point
  1. and rounds it off to the
  1. nearest number
  2. Adds the local currency symbol
  1. after the number
  2. If there is no decimal,
  1. the whole number is displayed.
4-1000.234($0,0)($1,000)
  1. Adds separators in the whole number where appropriate
  2. Rounds off to the nearest whole number
  2. Adds the local currency symbol before the number
  2. Negative numbers are in parentheses.
5-1000.234$0.00-$1000.23
  1. Adds two
  1. decimal numbers after the decimal point
  2. Rounds off to the nearest number
  2. Adds the local currency symbol before the
  1. number 
61230974($ 0.00 a)$ 1.23 m
  1. Displays the nearest thousandth with two
  1. decimal numbers after the decimal
  1. point
  2. Adds a letter for the magnitude change
  2. Adds the local currency symbol before the number

...


  2. Negative numbers are in parentheses.

Formatting Guide for Bytes 

raw format.Divided and add 'KB' .Divided and add 'KiB' Divided digit and rounds and add 'KB' . digits and add 'GB' . digits and add 'TiB' .
OrderField Value (
Raw Format) FormattingOutputDescription
11000b100B

Adds "B" after the number

210240b1KB
  1. Divides by 1000 and rounds off to the nearest whole number
  2. Adds "KB" after the number
320480 ib2 KiB
  1. Divides by 1024 and rounds off to the nearest whole number
  2. Adds "KB" after the number.
430720.0 b3.1 KB
  1. Divides by 1000 and adds one
  1. decimal number after the decimal point
  2. Rounds off to the nearest number
  2. Adds "KB" after the number

578844862130.00b7.88GB
  1. Displays the nearest thousandth with two
  1. decimal numbers after the decimal
  1. point
  2. Adds "GB" after the number
634674796827870.000 ib3.154 TiB
  1. Displays the nearest thousandth with three
  1. decimal numbers after the decimal
  1. point
  2. Adds "TiB" after the number

Formatting Guide for Percentages

raw format. digits and rounds and adds ..Multiply digits and rounds .If the number is negative, it shows in parenthesis.
OrderField Value (
Raw Format) FormattingOutputDescription
110%100%

Multiplies the value by 100 and adds a percent sign

20.9748782340.000%97.488%
  1. Multiplies the value by 100 and adds three
  1. decimal numbers after the decimal point
  2. Rounds off to the nearest number
  2. Adds a percent sign
3-0.430 %-43 %

Multiplies the value by 100 and adds a percent sign

40.43(0.000 %)43.000 %
  1. Multiplies the value by 100 and adds three
  1. decimal numbers after the decimal point
  2. Rounds off to the nearest number and adds a percent sign
  2. Negative numbers are in parentheses.

Formatting Guide for Time

raw formatSeconds: seconds  position and 3600：Minutes: Divide by 60 to get Seconds: Multiply the decimal part of the result from dividing by 60 by 60 to get the seconds 3600：
  • Hours: Divide by 3600 to get the integer part.
  • Minutes: Multiply the decimal part of the result from dividing by 3600 by 60 to get the integer part.
  • Seconds: Multiply the decimal part of the result from dividing by 3600 by 60 to get the decimal part, then multiply the result by 60 to get the seconds. 
OrderField Value (
Raw Format) FormattingOutputDescription
12500:00:000:00:25
Numbers less than 60 are displayed in the
seconds section.
223800:00:000:03:58

For numbers greater than or equal to 60

but less than

3600:

  1. To show minutes, divide the input by 60 and use the integer part.
  1. Example: 238 / 60 = 3.966666
    Take the whole number 3 to have 0:03:00.
  2. To show seconds, take the quotient of the example above and multiply it by 60 and round it off to the whole number.
    Example:  .966666 x 60 = 57.9999, rounded off to 58

Hence, the output is 0:03:58.

36384600:00:0017:44:06

For numbers greater than or equal to

3600: 

  1. To show hours, divide the input by 3600 and use the integer part. 
    Example: 63846 / 3600 = 17.735 
    Take the whole number 17 to have 17:00:00.
  2. To show minutes, take the decimal numbers in the quotient and multiply them by 60. 
    Example:  .735 x 60 = 44.1
    Apply the whole number to have 17:44:00
  3. To show seconds. take the decimal numbers in the product and multiply them by 60. Example: .1 x 60 = 6 

Hence, the output is 17:44:06.

Formatting Guide for Exponential

raw format and add 'e', and  add digits and add 'e' and add, subtract . digits and add 'e' , subtract .
OrderField Value (
Raw Format) FormattingOutputDescription
111234567890,0e+01e+9
  1. Displays the nearest thousandth with the whole number
  2. Adds "e" and a
  1. 10-based exponent when the exponent is positive
  2. If the exponent is negative,  subtract when the exponent is negative.
212398734.2020.00e+01.24e+7
  1. Displays the nearest thousandth with two
  1. decimal numbers after the decimal
  1. point
  2. Adds "e" and a 10-based exponent when the exponent is positive
  2. Subtracts when the exponent is negative
30.0001239870.000e+01.240e-4
  1. Displays the nearest thousandth with three
  1. decimal numbers after the decimal
  1. point
  2. Adds "e" and add10-based exponent when the exponent is positive
  2. Subtracts when the exponent is negative