FRACTIONALPART Function

From Planfix
Revision as of 12:12, 26 November 2025 by Dmitri (talk | contribs) (→‎Go To)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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