{"id":10167,"date":"2016-02-25T09:51:31","date_gmt":"2016-02-25T01:51:31","guid":{"rendered":"http:\/\/localhost\/help\/p2-server\/calculations\/numbertostring\/"},"modified":"2024-01-17T10:48:04","modified_gmt":"2024-01-17T02:48:04","slug":"numbertostring","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/numbertostring\/","title":{"rendered":"NumberToString()"},"content":{"rendered":"\n<h2><span id=\"Format\">Format<\/span><\/h2>\n<p class=\"intro-text\"><strong>NumberToString(Number [,Decimals] [,TrimZeros])<\/strong><\/p>\n<h2><span id=\"Returns\">Returns<\/span><\/h2>\n<p class=\"intro-text\">Converts the supplied number into a string.<\/p>\n<h2><span id=\"Parameters\">Inputs<\/span><\/h2>\n<p class=\"intro-text\"><strong>Number<\/strong>: The number to be converted into a string.<br \/>\nBehaviour: Required<br \/>\nDimension: Collection, SingleValue, MultiCollection<br \/>\nValid\u00a0data types: Decimal, Integer<\/p>\n<p class=\"intro-text\"><strong>Decimals<\/strong>: The\u00a0number of decimal places to use in the conversion. Specify\u00a0a value from 0 to 15. Default: 2<br \/>\nBehaviour:\u00a0Optional<br \/>\nDimension: Collection, SingleValue<br \/>\nValid data types: Decimal, String<\/p>\n<p class=\"intro-text\"><strong>TrimZeros<\/strong>: By default, any trailing zeroes after the decimal place are trimmed. Override this behaviour by passing False (or zero).<br \/>\nBehaviour:\u00a0Optional<br \/>\nDimension: Collection, SingleValue<br \/>\nValid data types: Boolean, Decimal, Integer, String<\/p>\n<p class=\"left-bar\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/calculation-syntax\/#Data_Type\">How to format data types<\/a><\/p>\n<h2><span id=\"Examples\">Examples<\/span><\/h2>\n<p class=\"intro-text\">Expression:\u00a0<span class=\"code-fragment\">NumberToString(56.3)<\/span><br \/>\nResult: 56.3<\/p>\n<p class=\"intro-text\">Expression:\u00a0<span class=\"code-fragment\">NumberToString(56.324)<\/span><br \/>\nResult: 56.32<\/p>\n<p class=\"intro-text\">Expression:\u00a0<span class=\"code-fragment\">NumberToString(56.324, 2)<\/span><br \/>\nResult: 56.32<\/p>\n<p class=\"intro-text\">Expression:\u00a0<span class=\"code-fragment\">NumberToString(56.324, 1)<\/span><br \/>\nResult: 56.3<\/p>\n<p class=\"intro-text\">Expression:\u00a0<span class=\"code-fragment\">NumberToString(56.324, 0)<\/span><br \/>\nResult: 56<\/p>\n<p class=\"intro-text\">Expression:\u00a0<span class=\"code-fragment\">NumberToString(56.324, 4, True)<\/span><br \/>\nResult: 56.324<\/p>\n<p class=\"intro-text\">Expression:\u00a0<span class=\"code-fragment\">NumberToString(56.324, 4, False)<\/span><br \/>\nResult: 56.3240<\/p>\n<p class=\"intro-text\">Expression:\u00a0<span class=\"code-fragment\">NumberToString({TagABC.PV})<\/span><br \/>\nResult: The numeric value of the tag TagABC.PV converted to a string.<\/p>\n<h2><span id=\"Release_History\">Release History<\/span><\/h2>\n<ul class=\"intro-text\">\n<li>NumberToString() 4.6.5\n<ul class=\"intro-text\">\n<li>Changed Number parameter to support MultiCollection values.<\/li>\n<\/ul>\n<\/li>\n<li>NumberToString() 4.0\n<ul class=\"intro-text\">\n<li>Initial version<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Use NumberToString() to convert a number into a string.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/numbertostring\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":10174,"parent":3650,"menu_order":146,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[9],"tags":[100,397,398],"class_list":["post-10167","page","type-page","status-publish","has-post-thumbnail","hentry","category-tech-ref","tag-calculations","tag-casting-functions","tag-number-to-string","Version-4-0","Version-4-6-5","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/10167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=10167"}],"version-history":[{"count":3,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/10167\/revisions"}],"predecessor-version":[{"id":64748,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/10167\/revisions\/64748"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3650"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/10174"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=10167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=10167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=10167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}