parenthesis around a numeric field pattern, and round it, please

[videostart]

I want to add parenthesis around a numeric field that has a currency patten so it will look like this:

($400)

I got the pattern to show the currency, but how can I add parenthesis around the value?

Also can I round the number so instead of $401.99, it would be $402?

Thanks!

[Former Community Member]

Use this as your display pattern. Make sure that you are using a numeric field.

num{'('$999')'}

Paul

[videostart]

Great thanks!