Smart Form amount field in parentheses

[rajesh_tummala5]

Dear Experts,

My smart form table has an amount field, for negative value its displaying like 1234.00-, so i used &AMOUNTFIELD(<)& to display it like -1234.00. Now our users want it like (1234.00) instead of a negative symbol.

Since this is a currency field how can i have the parentheses to the amount instead of a negative symbol.

Is there a provison in smart forms to have parentheses for negative amount fields.

if i dont have any other options, i have to take it into a character field and concatenate '(' and ')' on left and right of the amount field.

Please suggest the best way to do it.

Thanks,

Rajesh.

[Former Member]

Hi,

First,

Create 2 text node in your currency display cell:

- 1 node for display negative currency: set condition of this text node should display when AMOUNTFIELD < 0 . In the text node show amount field with no sign and set parentheses (&AMOUNTFIELD(S)&).

- 1 node for display non negative and set condition AMOUNTFIELD >= 0. show amount by &AMOUNTFIELD&

other way is you write amountfield to var no-sign then set if it's negative then we concatenate parenthese for it.

THanks,