Re: How to show in a Currency format a numeric caluclated field column value in SharePoint Form Library?

SRAEngineer — Thu, 17 Mar 2016 20:35:29 GMT

This is resolved. Someone suggested to add each column instead of concatenation and that worked!

Thanks regardless...

How to show in a Currency format a numeric caluclated field column value in SharePoint Form Library?

SRAEngineer — Thu, 10 Mar 2016 14:43:55 GMT

I have three large content based InfoPath forms (namely C, CO and L) published to a single SharePoint Form Library. Each form generates a dollar value after some calculations within the form in a numeric format. These numeric fields (namely TotalestprojectcostC, TotalestprojectcostCO and TotalestprojectcostL respectively) are promoted to the SharePoint Form Library. In the Form Library, I have a calculated field titled "totalestprojectcost" with a formula:

=CONCATENATE([TotalestprojectcostC],[TotalestprojectcostCO],[TotalestprojectcostL]) to bring all the field values coming from each submission of a form regardless of the content type under single column.

How can I show the numeric value of the field "totalestprojectcost" in a currency format? (e.g., $2,50,000 or $150,000)

Is it possible?
Thank you,

SRA

SharePoint Integration

Re: How to show in a Currency format a numeric caluclated field column value in SharePoint Form Library?

How to show in a Currency format a numeric caluclated field column value in SharePoint Form Library?