Percent Format - in a custom string

[Former Member]

Post Author: rjstassi

CA Forum: Formula

I have a custom field with the string "("&&"Complete)"

the formula works - however, I need the rounded to the whole percent i.e. 41.67 => 42 and I need the % symbol. I know I can add the '%' symbol into the string portion, but I cannot round the number as it becomes recognized as a string.

Rick in Sacramento

[Former Member]

Post Author: rjstassi

CA Forum: Formula

worked great. (I used suggestion 2:) Thanks

Rick

[Former Member]

Post Author: bettername

CA Forum: Formula

There's two spring-to-mind options:

1: Place a textbox on the page, type in the text bits "( % Complete)" and then drag+drop the field into the middle of the text string in the textbox. You can then format the number portion of the textbox as another other normal number field. I prefer to leave the % sign as part of the textbox rather than as part of the number formatting. For no particular reason, mind you. 2: Change the formula to be: "("&totext(,0)&" % Complete)". This will convert the number to text (the ,0 bit rounds it) and allows it to be concatenated with other bits of text.