Views:

Product: LABELVIEW, CODESOFT

Version: All Versions

 

 

fixed («value» , «num_decimals», «non_sep»): Returns a string of formatted characters with a number of decimals equal to num_decimals and with or without a thousands separator.

Examples:
fixed (1234.5678, 3, TRUE) = "1234.568"
fixed (1234.5678, 3, FALSE) = "1,234.568"


Note: The thousands separator to be displayed must be defined in the Output tab of the Formula data source by checking the Display decimals box.