Format within a calculated field and Text Box with Script
Forum Members,,, I am almost done with my project, I have to items I am currently trying to resolve:
1) How to format a number (result of calculation) within a text statement within a calculated field. Example:
"After expiration penalty of $" & .02*Original Bill &" and daily interest of $"&.01*(1.02*Original Bill)&"."
How can I format the number results " & .02*Original Bill &" to appear $#,###.00
2) I have created an output table that will generate information based on a single Client ID. How can I create a script, that will bring up a text box that will ask me to input the desired Client ID, and then the calculated fields can refer to that Client ID to run their related Lookups?