AnsweredAssumed Answered

Format within a calculated field and Text Box with Script

Question asked by MichaelShea_1 on Jan 24, 2015
Latest reply on Feb 1, 2015 by philmodjunk

Title

Format within a calculated field and Text Box with Script

Post

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?

Much appreciated!!!
 

Outcomes