negative values not showing up in NUMERIC display pattern Szzz,zzz,zz9.99

[Former Member]

Hi,

I want to use numeric field type and display pattern Szzz,zzz,zz9.99.

I don't see neagtive numbers with this format?

What do I need to change?

Rgds

Vara

[Former Member · Accepted solution]

Hi Vara,

To include negative numbers in format pattern include the pattern inside the brackets.try this ($zzz,zzz,zz9.99) or this formatt $szzz,zzz,zz9.99.

Thanks and Regards,

Siva

[Former Member · Accepted solution]

siva,

I tried both of them with numeric type.I am still not getting my neagtive values.

When I tried ($zzz,zzz,zz9.99) & $zzz,zzz,zz9.99 ..I am geting output as $ 0.00

If I change object type to TEXT I am getting my value.. but output is like this

2123123.-

I need it as

2,123,123.00-

I am ok using TEXT type too but i am missing those zero's..

Rgds

Vara

Edited by: Vara K on Feb 23, 2009 2:20 PM

[Former Member · Accepted solution]

Vara,

Try using Decimal field as object type instead of Text or Numeric fields.

I tried with decimal field and its working fine.

Thanks and Regards,

Siva

Edited by: Siva on Feb 23, 2009 5:13 PM

[Former Member · Accepted solution]

Hey Vara,

Sorry, I posted something you already have... Let me look, I've had this working before...

Cheers,

Kevin

[Former Member · Accepted solution]

Siva,

Problem solved ! with decimals.

rgds

Vara