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