Hi!
I am trying to format input into a currency format ($xxx.xx).
I receive the numerical value which is often calculated (eg 1.65348653) and wish to round this.
I have tried following the guidance here but so far been unsuccessful:
https://plumsail.com/docs/documents/v1.x/document-generation/common-docx-xlsx/formatters.html
The date formatting works fine, and is currently implemented, but so far none of the numeric values work.
I have tried an array of possible methods which have all not worked:
{{Total Package Funds:format(N2)}}
{{Total Package Funds}:format(P)}
{{Total Package Funds}:format(C)}
{{Total Package Funds}:format(āCā,en-US)}
{{ Total Package Funds }:format(C0)}
I've tried passing data as both a value from SharePoint, or hardcoding a number into the output template data.
The output continues to be unrounded:
I've also looked here and tried to guess the formatting, but this hasn't worked.
I've also tried adjusting the "token type" but I believe this might just be for autogenerating forms.
Interestingly, using something like {Total Package Funds}.Length} returns the number of characters, so it seems to be able to handle the number as a "string". I'm unsure how to get it to treat the input as a numerical type (and thus allow it to be formatted).
Thanks!