Hi Community,
I have a decimal field "UsrGrandTotal". I am showing this field in my word printable. How can I format the value of my field as below:
Value: 2415.00
Must show as like this: 2,415.00
I found below link in academy but the problem is that, If the fractional part is zero, it will not be displayed. I need to show both the comma delimiter and the fractional 0 in 2 digits
https://academy.creatio.com/documents/technic-sdk/7-16/basic-macros-ms-…
Like
Dear Fulgen,
It’s possible to create a custom macros if there is no basic macros that would suit your business task. Please find the example of creating the custom macros in the article by the link below:
https://academy.creatio.com/documents/technic-sdk/7-16/how-create-macros-custom-report-word
Best regards,
Norton
I have an article with a sample here that is pretty close to what you're after, this custom macro will format money as $2,415.00 (based on the culture in the macro). You can see this article here https://customerfx.com/article/creating-custom-macros-to-format-values-in-word-printables-for-creatio-formerly-bpmonline/ You could use it as a starting point for yours and just replace the line
result = currency.ToString("C", new CultureInfo("en-US"));to something like this
result = number.Format("{0:n}");Ryan
