Re: Dollar Amounts not displaying properly if cents are ".00" in the document library

Hilary Stoupa — Thu, 21 May 2020 21:42:05 GMT

So - I don't really have an answer to your question directly, but do have something you might try as a work around.... Is the data type of the field in InfoPath a number? If so, just promote the number, and add a calculated column that formats it as currency, then use that in your SharePoint Designer workflow?

Dollar Amounts not displaying properly if cents are ".00" in the document library

dapklp — Thu, 21 May 2020 12:36:17 GMT

I’m having problems with a dollar field from an InfoPath form, displaying properly in the SharePoint Designer generated e-mail. Everything is fine, unless the dollar amount ends in “.00”, then all I get is a single decimal place (for example, I have numbers that display as “$1,1200.0”; $450.0; and $7000.0”).

My original field to capture the amount is Text Decimal (double) with Format: Currency symbol ($English (United States)), 2 Decimal places, and Use a digit grouping symbol like this ($1,234.12). It shows up in my document library column as “1500.0”

So, when this field is not blank, I have it automatically copy itself to 2 other text fields where I do a lot of manipulation by determining how many characters are in this piece of text, adding “00” if the users just typed 500, for example, and add a dollar sign so the number displays with a $ in the document library.

With all I do, I get these results for my 1 original field and 3 manipulated/concatenated fields:

TB Bill Amount Text: 1500.0
TB Bill Amount 4 Email: $1500.0
TB Bill Amount Text TEST: 1,500
TB Bill Amount 4 Email TEST: $1500.0

Any suggestions on getting a dollar amount to display as a 2-decimal dollar amount, even when the cents are “00”?

SharePoint Integration

Re: Dollar Amounts not displaying properly if cents are ".00" in the document library

Dollar Amounts not displaying properly if cents are ".00" in the document library