Format Numbers - Audit Tab (5 replies)
Use the Format function in a Map transform:
Format(%Field, "Currency")
Format(%Field, "Currency")
Thanks! I was trying FormatNumber()
Actually, now I am receiving this as the result. Format(0 "Currency") Debits
Michael, you cannot put VBScript into the Audit Reports; the value must be formatted in a transform prior, or the same transform if it permits you.
And it appears you've missed a comma between the field and the format string.
OK, thanks for confirming my thought with the Audit Reports. I apologize for quickly reading the comment above the formula in your earlier post.
Is it possible to format the numbers as part of the audit email sent from IMan? Since the data fields do not have commas, the results send as 100000.25 instead of 100,000.25.
Thanks