FRACTIONALPART Function: Difference between revisions

From Planfix
Jump to: navigation, search
(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...")
 
 
Line 20: Line 20:


== Go To ==
== Go To ==
*[[Functions]]
*[[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.


Go To