FRACTIONALPART Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=FRACTIONALPART Function |titlemode=append |keywords=planfix, Templates, documents, functions, document templates, functions in document templates, FRACTIONALPART |description=FRACTIONALPART Function }} This function displays the fractional part of a number. You can specify the number of digits after the decimal point you would like to see. == Format: == <nowiki>FRACTIONALPART(number; NumberOfDigitsAfterDecimal)</nowiki> == Examole == To output the number...") |
(→Go To) |
||
| Line 20: | Line 20: | ||
== Go To == | == Go To == | ||
*[[ | *[[Standard functions]] | ||
Latest revision as of 12:12, 26 November 2025
This function displays the fractional part of a number. You can specify the number of digits after the decimal point you would like to see.
Format:
FRACTIONALPART(number; NumberOfDigitsAfterDecimal)
Examole
To output the number of cents for the cost of a service in a document, use the following function:
FRACTIONALPART(SUM({{DataTag.Service.Cost}}*{{DataTag.Service.Quantity}}); 2)
This function displays the two digits after the decimal point:
- 176.03 — function returns 3.
- 15.15 — function returns 15.
- 16.156 — function rounds first two decimal points to 16.